Formatting Column ??

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

Hi all
Just a quick question. I have two cloumns one is formatted currency the
other is number and I calculate into cloumn 3 which is set to currency.
How do I set the format in column 3 to show $ amnts when needed but not show
anything until then.
Right now I have a cloumn showing $0.00.

TIA
Donny
 
Either:-

=IF(My_Formula=0,"",My_Formula)

or format Col 3 using Fomrat / Conditional formatting - Cell value is equal to
0 - Hit format button and choose white font.
 
Back
Top