Formula Help

[mikesal57]

Hello ......

I have Cells A B C

A & B will have numbers 1 thru 20......no zero's or negative numbers

I need C to be 1 if criterias are met .......0 if not met

Criteria:

if A is 1........B can be anything.............C gets a 1

if A is 2........B must be >=7.................C gets a 1

if A is 3........B must be >= 11..............C gets a 1

all other scenarios get a .....0 in C


Thx

 

[jproffer]

Give this a try. In C1, drag down as you wish...

=IF(OR(AND(A1=1,B1<>""),AND(A1=2,B1>6),AND(A1=3,B1>10)),1,0)

 

[mikesal57]

Give this a try. In C1, drag down as you wish...

=IF(OR(AND(A1=1,B1<>""),AND(A1=2,B1>6),AND(A1=3,B1>10)),1,0)

As always...you guys ROCK!!!

Thxs

 

[jproffer]

There are those that know me that would argue that lol. I'm glad it worked for you.