converting a $0 to a $- (blank)

[jsflbot]

Hello,

How can I covert a formula result of $0.00 to $- and act as a blank?

I have the following formula, but I want $0.00 results to be picked up as a blank ISBLANK

=IF(AND(ISNUMBER(D14),ISBLANK(E14)),"New Fallout", IF(AND(ISBLANK(D14),ISNUMBER(E14)),"New Sale","No Change"))

Thanks!

 

[Brian from Maui]

Have you tried formatting the cell as Accounting?

 

[JoeMo]

You can format the cell as $#,##0.00;;$- to have $0.00 appear as $-, but the cell will not be blank and ISBLANK will return FALSE. Why not use:

=IF(AND(ISNUMBER(D14),E14=0),"New Fallout", IF(AND(ISBLANK(D14),ISNUMBER(E14)),"New Sale","No Change"))

 

[jsflbot]

thanks @JoeMo!

 

[JoeMo]

thanks @JoeMo!

You are welcome - thanks for the reply.