empty display in place of 0.0 ... possible?
Instead of:
=CONVERT(1000*A1,"g","lbm")
use:
=IF(A1="","",CONVERT(1000*A1,"g","lbm"))
--
Gary''s Student - gsnu2007k
"Dave Horne" wrote:
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
|