Dollar Sign conditional display

N

nine

I am creating an invoice and would like the Dollar Sign to not be displayed
in a column when the row is blank, and to be displayed when there is data in
the row. Is this possible?

Thanks
Dave
 
G

Gord Dibben

If the cell is truly blank no currency sign will show.

I assume you have a formula like =A1*B1 in the cells but no data in the
reference cells.

Perhaps a trap....

=IF(OR(A1="",B1=""),"",A1*B1)


Gord Dibben MS Excel MVP
 
N

nine

Thanks for the help
Dave


Gord Dibben said:
If the cell is truly blank no currency sign will show.

I assume you have a formula like =A1*B1 in the cells but no data in the
reference cells.

Perhaps a trap....

=IF(OR(A1="",B1=""),"",A1*B1)


Gord Dibben MS Excel MVP
Click to expand...
 
J

JON JON

Alternatively:

with the cells selected

1) Goto Format>Cells
2) Choose the "number" tab
3) On category list choose "Custom"
4) on the "type" box write $#,##0_);($#,##0);""

You can also use 0 instead of "" depending on what you want
 
Top