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

"Jeremy" wrote:

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
S83AD83<=AC83 4
S83AC83<=AB83 3
S83AB83<=Z83 2
S83Z83 1

Does this make sense?