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