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
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