empty display in place of 0.0 ... possible?

  • Thread starter Thread starter Dave Horne
  • Start date Start date
D

Dave Horne

Someone here was kind enough to provide a formula which converts kg in one
column to lbs in another.

Is it possible where there is no kg value, that the lb value instead of
displaying 0.0, displays an empty cell?

Thanks, Dave Horne Excel 2007
 
One way is to apply conditional formatting to the cell, such that if
the cell value is zero then the foreground colour is set to white (so
it appears blank).

Hope this helps.

Pete
 
Instead of:
=CONVERT(1000*A1,"g","lbm")
use:
=IF(A1="","",CONVERT(1000*A1,"g","lbm"))
 
Try this:
=IF(ISBLANK(A1),"",A1*0.31)
Replace 0.31 by the real kg to lb rate!

Regards,
Stefi

„Dave Horne†ezt írta:
 
Thanks to everyone who responded! I'm sorting through all the
possibilities.

Thanks, Dave Horne


One way is to apply conditional formatting to the cell, such that if
the cell value is zero then the foreground colour is set to white (so
it appears blank).

Hope this helps.

Pete
 
Back
Top