3 conditions coming from one cell.. Nested If Statement??

**trosasco** · 05-07-2013, 12:53 PM

Can someone please help me out with this formula? In English I’m trying to say:
If the words “CANCEL”, “Cancel – Non-Pay”, or “Cancel-Pend Rel/NOC” are in column A, then count as 1, if not 0..

This is what I thought was right…Apparently not..

=IF(or(A:A=”CANCEL”,”Cancel – Non-Pay”,”Cancel-Pend Rel/NOC”,1,0))

What did I do wrong?

**AndyLitch** · 05-07-2013, 01:01 PM

Change it to =IF(OR(A1="Cancel",A1="CANCEL",A1="Cancel-Pend Rel/NOC",A1="Cancel – Non-Pay"),1,0) and paste it down a parallel column.

There was something wrong with the quotation marks but I'm not sure what

**judgeh59** · 05-07-2013, 01:15 PM

so, in english, you are trying to count how many times "CANCEL", "Cancel...","Cancel..." occur...is that correct?

**AndyLitch** · 05-07-2013, 01:17 PM

No .. if cell A1 has any one of the text values it will score a 1 ... if not a zero

**trosasco** · 05-07-2013, 01:26 PM

Thank you Andy.. It worked.

**AndyLitch** · 05-07-2013, 02:14 PM

You're welcome

**trosasco** · 05-08-2013, 02:35 PM

Same report - different formula and a little tougher..

I have a column where i have to track all the Active files in Illinois only. The problem is that there are a lot of different types of "Active" files - All these files are considered "Active":

Column F = Active
Column G = Pending
Column K = Welcome Call
Column L = 90-Day Savings Hold
Column M = Temp-Active
Column P = Active-No Funds
Column Q = Pending-No Funds

I created a column for each of them with their own totals. How do I create a formula that will count all these columns and only for the state of IL? The IL column is column S.

**AndyLitch** · 05-08-2013, 02:52 PM

Dude...
You need to copy paste the above into a new thread.... It's forum rules but also more likely to get you a quicker (and probably better) response..