Zero to return as Blank

[sadiejay]

I have a formula referring to whether another cell is blank (bu way of using ""). However I need "0" and "0.00" to be condidered blank for this purpose. How can I achieve this? Thanks!

 

[Andrew Poulsom]

What's your formula?

 

[sadiejay]

=IF(OR(AND(E8241=TRUE,OR(ISNUMBER(U8241),ISNUMBER(V8241),(ISNUMBER(W8241)))),(AND(E8241=FALSE,U8241="",V8241="",W8241=""))),"MATCH","NOTMATCH") I have just realised I also need the "isnumber" earlier in the formula to not consider 0 as a number.

 

[Andrew Poulsom]

In what way is zero not a number? Can you explain in words what constitutes a MATCH?

 

[sadiejay]

http://www.mrexcel.com/forum/excel-questions/822161-if-statement.html <-- this is my original forum question where some people kindly helped me create the formula in the first place. Hopefully it will explain better where I am coming from and what MATCH means, etc. Zero is not a number in that in my spreadsheet a number is a cost, therefore if a zero is returned, it's not an actual cost. Hope this makes sense

 

[pjmorris]

Apologies if I'v completely missed the point, but a simple way of showing a blank when you have 0 in a cell is to custom format it as "General;-General;"