hide zero values in M365

Copper Contributor

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

@lezli2360 

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.