Trouble with an IF formula

G

glenn

I have an IF formula which selects a date (in text format) and, if the
criteria is met, will perform a calculation. It works fine except it returns
a value error when the date I'm looking for isn't in the field. I'm looking
to have it return 0 instead of value.
 
S

SimonCC

Can just add another IF outside of your formula:
=IF(ISERROR(YourFormula),0,YourFormula)

-Simon
 
Top