Formula Help with NonText and Blank Cells

[yani06]

This is my formula:

=IF(ISNONTEXT(E3),"$200")

Although is working for the non text (since E3 contains a date), I want it to return 0 if E3 is blank.

Can someone help?

 

[CWatts]

=IF(E3="",0,IF(ISNONTEXT(E3),"$200"))

or

=IF(ISBLANK(E3),0,IF(ISNONTEXT(E3),"$200"))

 

[yani06]

Thanks. That works. But I have another related question. When I want to add the column, it won't add the $200. Is there something in my formatting of cells that should be changed. Thank you.

 

[CWatts]

Yes because you put the $200 in quotes, it's being treated as text, and text has a "value" of 0.

If you want it to be a numerical value, change your formula to:

=IF(E3="",0,IF(ISNONTEXT(E3),200))
or
=IF(ISBLANK(E3),0,IF(ISNONTEXT(E3),200))

and then format the cell as currency.

 

[yani06]

Thank you! It's fixed!