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.

Trouble with an IF formula
 

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.