How do I not display the Euros sign, if value is 0?
 

I have spread sheet that has many lines that converts dollars to Euros, but
if dollars are not input on a line, I would like the cell to be blank and not
the the Euro sign and a dash. Anybody have an answer?

How do I not display the Euros sign, if value is 0?
 

Is this any help:

=IF((A16*B16)=0,"",(A16*B16))

Basically if the result of A16 * B16 is 0 put nothing ("") in the cell,
otherwise perform the formula. Ensure that the cells are formatted to
show Euros (right click format cells currency.

Thanks
gazzr


--
Gazzr
------------------------------------------------------------------------
Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075
View this thread: http://www.excelforum.com/showthread...hreadid=539127

How do I not display the Euros sign, if value is 0?
 

Thank you so much! It worked. I appreciate your time to help me.
Connie

"Gazzr" wrote:


Is this any help:

=IF((A16*B16)=0,"",(A16*B16))

Basically if the result of A16 * B16 is 0 put nothing ("") in the cell,
otherwise perform the formula. Ensure that the cells are formatted to
show Euros (right click format cells currency.

Thanks
gazzr


--
Gazzr
------------------------------------------------------------------------
Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075
View this thread: http://www.excelforum.com/showthread...hreadid=539127