Help with Nested IF/And Function
 

I am having trouble getting this to work. I can do about 2-3 of the
statements but stringing them all together is proving difficult.

Values C3 Compared to E3.

First Condition
If C3=E3 return value of 1

Second Condition
If C3=600 Return value of 3

Third Condition
If C3E3 AND C3399 return value of 2

4th Condition
If C3<400 and E3<400 return value of 1

5th Condition
If C3399 and C3<E3 return value of a 1

Else return 0.

That should be checked in that order.

Help with Nested IF/And Function
 

That should be checked in that order.

OK...but these are duplicates:

Third Condition
If C3E3 AND C3399 return value of 2
4th Condition
If C3E3 AND C3399 return value of 2

=IF(C3=E3,1,IF(C3=600,3,IF(AND(C3E3,C3399),2,IF( AND(C3399,C3<E3),1,0))))


--
Biff
Microsoft Excel MVP


"Bombay" wrote in message
...
I am having trouble getting this to work. I can do about 2-3 of the
statements but stringing them all together is proving difficult.

Values C3 Compared to E3.

First Condition
If C3=E3 return value of 1

Second Condition
If C3=600 Return value of 3

Third Condition
If C3E3 AND C3399 return value of 2

4th Condition
If C3E3 AND C3399 return value of 2

5th Condition
If C3399 and C3<E3 return value of a 1

Else return 0.

That should be checked in that order.