Want blank to be displayed not 0:00

  • Thread starter Thread starter Mike Klick
  • Start date Start date
M

Mike Klick

I have this formula:

=IF(H19="Minimum","0:30",ROUND((E19-D19)*96,0)/96)

In a cell with Custom [h]:mm format. It shows 0:00 when there is no data. I
would like it to be blank. How?

Also:

=G19*24*L19

In a cell with Currency amouts. Can I make it blank too?

Thanks,

Mike
 
=IF(IF(H19="Minimum","0:30",ROUND((E19-D19)*96,0)/96)=0,"",IF(H19="Minimum",
"0:30",ROUND((E19-D19)*96,0)/96))


=IF((G19*24*L19)=0,"",G19*24*L19)

Vaya con Dios,
Chuck, CABGx3
 
Hi Mike

It's not possible to have a formula cell be truely blank. You can use ""
to be returned but this is Text and often not formula friendly. You are
often better off leaving the 0 in the cell and simply hidding it with a
Custom format like

[h]:mm;[h]:mm;

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
 
Back
Top