Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide #Value!
=IF(H38=0,"",(($C59+C60)/$H38))
I've read the techniques for hiding the #Value! when empty but need help. I tried doing it with ideas in the forum but it's not working the way I do it. Please help. Ciao Darrell |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide #Value!
=IF(H38=0,"",(($C59+C60)/$H38))
If there are TEXT entries in any of those cells then you'll get the #VALUE! error. How to deal with that depends on what result you want if 1, 2 or all 3 of the cells are either empty or contain text. Try this: =IF(H38=0,"",IF(ISNUMBER(H38),SUM($C59:C60)/$H38,"")) -- Biff Microsoft Excel MVP "brainstewn" wrote in message ... =IF(H38=0,"",(($C59+C60)/$H38)) I've read the techniques for hiding the #Value! when empty but need help. I tried doing it with ideas in the forum but it's not working the way I do it. Please help. Ciao Darrell |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide #Value!
=IF(OR(H38=0,H3=""),"",(($C59+C60)/$H38))
-- HTH Kassie Replace xxx with hotmail "brainstewn" wrote: =IF(H38=0,"",(($C59+C60)/$H38)) I've read the techniques for hiding the #Value! when empty but need help. I tried doing it with ideas in the forum but it's not working the way I do it. Please help. Ciao Darrell |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide #Value!
The 3 was a slip, obviously it should also be 38
-- HTH Kassie Replace xxx with hotmail "brainstewn" wrote: =IF(H38=0,"",(($C59+C60)/$H38)) I've read the techniques for hiding the #Value! when empty but need help. I tried doing it with ideas in the forum but it's not working the way I do it. Please help. Ciao Darrell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want to Hide columns in spreadsheet but NOT hide data in chart. | Charts and Charting in Excel | |||
How do I hide hide #REF! in Excel | Excel Discussion (Misc queries) | |||
hide code does not hide | Excel Discussion (Misc queries) | |||
Hide Unhide Hide again | New Users to Excel | |||
How do I hide a worksheet in Excel and use a password to un-hide . | Excel Discussion (Misc queries) |