Writing an "IF" Statement

[Paula]

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.

 

[papou]

Hello
=IF(AND(D2>=95,E2<0),2,IF(AND(D2>85,D2<=94.9,E2<0),1,IF(AND(D2<85,E2
<0),0,"""")))

HTH
Cordially
Pascal

 

[Ron Coderre]

Try something like this:

=SUM(--(D2>={85,95}))*(E2<0)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP