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

G

Guest

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do i input euros and have it convert into dollars in the same. 1
how do i get euros instead of dollars from currency icon 2
Currency Marker in Conditional 1
How do I convert euro to us dollars in excel? 1
How do I convert from Euros to USDollars? It's not in EUROCONVERT 1
How do I calculate and display in British Pounds and/or Euros? 4
Formulas with no results 3
how do i change euros into australian dollars 1

Top