ExcelBanter - Hide Error Message

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Hide Error Message (https://www.excelbanter.com/excel-discussion-misc-queries/109910-hide-error-message.html)

laurie g

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

Ian

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

laurie g

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

Ian

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

All times are GMT +1. The time now is 03:58 PM.