Forum Discussion
Online Excel Formula Returns Value Instead of Blank
In regular desktop Excel the below formula would make the cell blank (no value). However, in the web version of excel, it is returning a value of 0. I need it to return a blank as the 0 value will ca...
In Excel no one formula returns blank as a value, that's awaited functionality. In your case formula returns empty string "", but that's not a blank cell which considered as zero in calculations. For example, if your formula in A1 and it returns empty string, =A1+1 shall give #VALUE! error. If A1 is actually blank result will be 1.
Two variant - or Excel Online in your case has some advanced functionality (or bug), or your copy/paste incorrectly. Without the sample file it's hard to say more.
Sample could be as simple as: in A1 is 1, in B1 is 0, in C1 is =IFERROR(A1/B1,"")