Trouble with an IF formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Returning 1 of 4 values if conditions are met 4
Excel formula, sum the value cell and if empty cell left blank 0
if formula - multi criteria 6
Please help with formula 2
Workday Formula to include date 0
If formula current/expired/blank 3
If and Vlookup 3
Conditional Sum formula 4

Back
Top