Using IF and empty quotes to check for blank value

[Steven]

One of our clients has spreadsheets using IF(A10="",'N/A', 1) but this does not work it will display the 1 with an empty cell. However if IF(ISBLANK(A10),'N/A',1) is used it works properly. Is there a reason for this behavior or maybe a fix without having to change a ton of formulas across several hundred files?

[Nencho]

Hello, Steven,

I'm afraid that the described issue is a bug, and you can find it logged in our issue tracking repo below:

https://github.com/telerik/kendo-ui-core/issues/5572

I'm afraid that there's no applicable workaround for the time being. Even if there was, it should have been manually applied in the spreadsheet instances, which is duplicating the effort of altering the IF usage with the ISBLANK. 

Having in mind the heavy data scenario that you have at your end, and the critical severity of this bug at your end, we will try to escalate its priority and evaluate whether we can come up fast with a fix.

In addition, I have updated your Telerik points for pointing that issue out.

Please accept our apologies for the inconveniences caused by this bug. 

Regards,
Nencho
Progress Telerik

[Nencho]

Hello, Steven,

I'm happy to inform you that the bug you reported is now fixed and you can get an advantage of the fix, by downloading the upcoming internal build, where the fix will be present. We release internal builds each Wednesday. 

Hope this information helps.

Regards,
Nencho
Progress Telerik

[Steven]

That is great news, thank you!