Trouble with an IF formula

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.

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

-Simon

"glenn" wrote:

> 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.