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

.

Relevant Pages

  • Re: $1500 Cash Reward---- Glad to Announce Two Thieves Caught
    ... kids, most of the stuff recovered, confessed and saved the state the time and trouble of prosecuting and proving ... ...
    (rec.aviation.homebuilt)
  • Re: for loop in prolog
    ... > NewValue is Start+Inc, ... but if you want to go into the trouble of proving a start ... Prev by Date: ...
    (comp.lang.prolog)
  • Re: Phaistos Disk side B
    ... When there are no smileys, you have some trouble to understand ... > jokes, don't you? ... I was stringing you along to see how you'd reply. ...
    (sci.lang)