Need help with buried IF statements.

M. David
M. David ✭✭✭✭✭

I need help with a formula that I think will have multiple IF statements. Please see below.

Capture.JPG

I am trying to determine the Maint Tech YTD Score. For the formula, we will only be using the "Community Average Score", "Company Wide Satisfaction Avg.", and the "Score Delta". We are comparing the Score Delta to the Company Wide Satisfaction Avg. If the Score Delta is plus or minus 2 points, we multiply the Community Average Score by 1. If the Score Delta is 3 or more points above the Company Wide Satisfaction Avg., they get a 1.1 multiplier. If the Score Delta is 3 or more points below the Company Wide Satisfaction Avg., they get a .9 multiplier.

I just realized I need to get clarification from my colleague on what to do with a score of 2.6. I am guessing the actual cutoff point will be 2.9. If a formula is offered up prior to getting clarification, I can adjust the formula suggested. Thanks for your help with this. As always, it is greatly appreciated.

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!