If/then/and

[brandon]

I want to write a statement saying this in column H...

IF A2=ED or 17 then G2<=1,1,0 AND if A2 is not ED or 17 then G2<=3,1,0

Basically...if A2 equals 17 or ED I want column H to look at G2 for 1 or lower and give it a 1 if it is one or lower. If it is 2 or higher then give it a 0.

If A2 is not 17 or ED then I want to use 3 as the criteria for getting a 1 or 0.

Is this possible? If so, what is the formula?

[contaminated]

Try this one

Please Login or Register  to view this content.

HTH

[brandon]

thanks a million! That formula really got me on the right path. This ended up giving me the fix:

=IF(OR(A2={17,"ED"}),IF(G2<=1,1,0),IF(G2<=3,1,0))

Saves a bunch of time

[contaminated]

If it meets your requirements, mark the thread as "SOLVED", and don't forget to add reputation by pressing blue scales on the right of your screen

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save