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)))))))

 

[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))))