Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
empty display in place of 0.0 ... possible?
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
empty display in place of 0.0 ... possible?
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 On Jan 7, 10:39*am, "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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
empty display in place of 0.0 ... possible?
Something like this
Assuming A2 contains the kg value =IF(A2="","",<formula involving A2) -- Max Singapore http://savefile.com/projects/236895 Downloads:22,000 Files:370 Subscribers:66 xdemechanik --- "Dave Horne" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
empty display in place of 0.0 ... possible?
Try this:
=IF(ISBLANK(A1),"",A1*0.31) Replace 0.31 by the real kg to lb rate! Regards, Stefi €˛Dave Horne€¯ ezt Ć*rta: 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 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
empty display in place of 0.0 ... possible?
Thanks to everyone who responded! I'm sorting through all the
possibilities. Thanks, Dave Horne "Pete_UK" wrote in message ... 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 On Jan 7, 10:39 am, "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
empty links display | Excel Discussion (Misc queries) | |||
Display empty cells | Excel Discussion (Misc queries) | |||
Display empty cells | Excel Discussion (Misc queries) | |||
place empty cell with zero | Excel Worksheet Functions | |||
How do I set a cell to "Empty" so that it does not display in a ch | Charts and Charting in Excel |