Hello everyone, I'm very new to excel, the company I work with gave me the task to come up with a bonus structure for our team since I kept asking them about it. As a beginner I do not no where to start, but I saw the following Nested If and would like to know how I can put this together in an logical excel format. Respectfully
Nested If Statement! - Excel
Excel Forum
Thank you in advance for all your help!
I am looking for the correct setup of a nested if statement with 4-5 arguments
if sales reach a certain thershold 1% bounus
if sales increase 5% - 10% = 2% bonus
if sales increase 11%-15% = 3% bonus
and if sales increase 15% = 4% bonus
Thanks again for all the help!