If E17 is greater than 0, you should get e17 formatted as currency.

However, if e17 is not greater than zero, you get zero displayed as text,
because you put it in quotes. Is this the problem you see? You get 0, rather
than $0.00?

If so, remove the quotes from the last zero. In addition, the plus sign before
e17 is superfluous. Your formula can be simplified as:

=IF(A1=0," ",IF(E170,E17,0))

which can be further simplified to:

=if(a1=0," ",max(e17,0))


--
Regards,
Fred


"Janna" wrote in message
...
I have a cell with the following formula:

=IF(A1=0," ",IF(E170,+E17,"0"))

I'd like to format the cell with a Currency symbol, but can't seem to figure
out how to do so. As long as the above formula is in the cell, the number
displays without the currency symbol, even though I've formatted it as
currency by going to format cells, number, currency.

If I remove the above formula and just type a simple formula like =A1*A2
the number is formatted correctly with the currency symbol.

What am I doing wrong? Thanks