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.