Hide Error Message

[laurie g]

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]

Try this:

=IF(ISNUMBER(SMALL(C7:E7,1)),SMALL(C7:E7,1),"")

 

[laurie g]

Thanks Ian

Try this:

=IF(ISNUMBER(SMALL(C7:E7,1)),SMALL(C7:E7,1),"")

 

[Ian]

No problem.

Thanks for the feedback.

--
Ian
--

Thanks Ian