Thread
:
Make Search formula evaluate to blank
View Single Post
#
2
Posted to microsoft.public.excel.programming
JakeyC
external usenet poster
Posts: 107
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.
Reply With Quote
JakeyC
View Public Profile
Find all posts by JakeyC