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 to get this result?
1 Reply
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.
