Nested If

[Jeremy]

I need some help creating a nested if formula. The goal is to get a score 0
through 5 for different parameters.

Condition Result (Score)
S83=0 0
S83<=AD83 5
S83>AD83<=AC83 4
S83>AC83<=AB83 3
S83>AB83<=Z83 2
S83>Z83 1

Does this make sense?

 

[Eduardo]

Hi,
something make no sense what if S83 is < than AC83, could you give an
example. thanks

 

[Jeremy]

I will clarify. I am tracking how long it takes to process a request. The
less time it takes the higher the score. The goals are different based on
the reason for the request. The cells populate based on a VLOOKUP and a
dropdown.

Score Time
1 Greater than or equal to Z83
2 Greater than or equal to AA83 but less than Z83
3 Greater than or equal to AB33 but less than AA83
4 Greater than or equal to AD33 but less than AB83
5 Less than or equal to AD

The below formula was what I started with, until I noticed that it was not
right


=IF(S86=0,0,IF(S86<AD86,5,IF(S86>AD86<AC86,4,IF(S86>AC86<AB86,3,IF(S86>AB86<AA86,2,IF(S86>AA86<Z86,2,IF(S86>Z86,1)))))))

 

[David Biddulph]

=IF(S83=0,0,IF(S83<=AD83,5,IF(S83<=AC83,4,IF(S83<=AB83,3,IF(S83<=Z83,2,1)))))

 

[Eduardo]

Hi Jeremy,
Could you provide with the # you have in Z83 to AC83

 

[Eduardo]

Hi Jeremy, I figure out use
=+IF(S83>=Z83,1,IF(S83>=AA83,2,IF(S83>=AB83,3,IF(S83>=AC83,4,5))))

 

[David Biddulph]

But you don't need the + sign, Jeremy
Eduardo keeps forgetting that we're talking Excel, not Lotus. :-(

And it would be AD83 (or AD33 ?), not AC83, if that is what you wanted. You
seem to have a rather different expression of the problem each time, but
hopefully you'll get the hang of the syntax of the IF function, and can
adjust according to what you do really want.