Dollar Sign conditional display

[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

 

[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

 

[nine]

Thanks for the help
Dave

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

 

[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