Help with Nested IF/And Function

[Bombay]

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 C3>E3 AND C3>399 return value of 2

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

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

Else return 0.

That should be checked in that order.

 

[T. Valko]

That should be checked in that order.

OK...but these are duplicates:

Third Condition
If C3>E3 AND C3>399 return value of 2
4th Condition
If C3>E3 AND C3>399 return value of 2

=IF(C3=E3,1,IF(C3=600,3,IF(AND(C3>E3,C3>399),2,IF(AND(C3>399,C3<E3),1,0))))