| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide Error Message
In cell G7 is =SMALL(C7:E7,1)
Trying to use =IF(ISERROR funct to return a blank cell instead of #num! when C7:E7 are blank Please advise Many thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide Error Message
Try this:
=IF(ISNUMBER(SMALL(C7:E7,1)),SMALL(C7:E7,1),"") -- Ian -- "laurie g" wrote in message ... In cell G7 is =SMALL(C7:E7,1) Trying to use =IF(ISERROR funct to return a blank cell instead of #num! when C7:E7 are blank Please advise Many thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide Error Message
Thanks Ian
"Ian" wrote: Try this: =IF(ISNUMBER(SMALL(C7:E7,1)),SMALL(C7:E7,1),"") -- Ian -- "laurie g" wrote in message ... In cell G7 is =SMALL(C7:E7,1) Trying to use =IF(ISERROR funct to return a blank cell instead of #num! when C7:E7 are blank Please advise Many thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide Error Message
No problem.
Thanks for the feedback. -- Ian -- "laurie g" wrote in message ... Thanks Ian "Ian" wrote: Try this: =IF(ISNUMBER(SMALL(C7:E7,1)),SMALL(C7:E7,1),"") -- Ian -- "laurie g" wrote in message ... In cell G7 is =SMALL(C7:E7,1) Trying to use =IF(ISERROR funct to return a blank cell instead of #num! when C7:E7 are blank Please advise Many thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking for gurus that knows show and hide functions on a pivot table? | Excel Worksheet Functions | |||
| How can I hide a range of columns without hiding charts there? | Charts and Charting in Excel | |||
| Can anyone tell me how to hide rows that have 0 values and text. | Charts and Charting in Excel | |||
| Cannot hide columns in Excel | Excel Worksheet Functions | |||
| Macro to hide blank cells in a range | Excel Discussion (Misc queries) | |||
Linear Mode
