I am trying to write an "IF" statement into a spreadsheet that will let the
user know if they are to advance to the next step or not. My formula will
incorporate the following information:

IF D2 is greater than or equal to 95.0 and E2 is less than 0 then I want the
answer to be 2

IF D2 is equal to 94.9 or greater than 85 and E2 is less than 0 then I want
the answer to be 1

IF D2 is less than 85 and E2 is less than 0 then I want the answer to be 0

Any assistance you can give to how I should write this statement is greatly
appreciated.
--
Paula