Thread: Hide Error Message
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
laurie g laurie g is offline
external usenet poster
  
Posts: 11
Default 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



Reply With QuoteReply With Quote