Forum Discussion
hide zero values in M365
I am using standard formulas in M365 to import information between sheets but when the criteria is null, the answer is being brought forward is 0. I want a blank. What do I need to add to my formulas...
Excel formulas don't return blank as value. Most common option is to return empty string. How to do depends on formula you use, for example =IF(A1="", A1, "").
Alternatively you may apply custom number formats which won't show zeroes.
It is also setting in Excel Options not to show zeroes, but I'd not recommend it.