IF statement needed to exclude criteria for calculation

**petevang** · 03-25-2013, 04:55 PM

I'm trying to use an IF Statement in a formula to exclude a classification from the calculation portion of the formula. I have 3 differnent status in my data set (active, closed and writeoff). I'd like to be able to use an If statement to say "IF Staus is not "writeoff" then calcuate data for active and closed accounts. Any idea how best to do this with an If statement?

**judgeh59** · 03-25-2013, 04:58 PM

I'm not sure how your data is laid out but a pivot table might work for you....if you could post a worksheet I might be able to help.....yes, there are formulas out there that will do this....

**petevang** · 03-25-2013, 05:18 PM

Is there a way between clause for within an IF Statement? If so, that would probably work. What I'm trying to get to is: If Delquent days are between 59 and 89 days then yes, if not then no. Any idea?

**judgeh59** · 03-25-2013, 05:21 PM

I don't believe there is a between clause....I beleive the IF(AND(YourDate >= "pick a date",YourDate < "pick a date"),"Then Do something for True", "Else do something for False")

HTH