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

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

HTH
Cordially
Pascal

"Paula" a écrit dans le message de news:
...
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

Try something like this:

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

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

XL2002, WinXP


"Paula" wrote:

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