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

[Connie]

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?

[Gazzr]

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

[Connie]

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
>
>