View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JakeyC JakeyC is offline
external usenet poster
 
Posts: 107
Default Make Search formula evaluate to blank

If you name your formula "MyFormula", use it in one of the error
functions such as:

IF(ISERROR(MyFormula)=TRUE,"",MyFormula)

See help for all the Error functions available.

For a zero, replace the "" with 0.