I think this needs to be an AND statement, not OR.
OR(D13=36.344,D13<39.549)

Try this.

=IF(AND(D550,E17=1,D13<36.344),1,IF(AND(D13=36.3 44,D13<39.549),2,IF(D13=39.549,3,0)))

Regards,
Paul

"TR Young" wrote in message
...
Ok, that is one step closer, however it is not returning a value of 3 if
D13=39.549.
I really appreciate the help so far!