Ok, so I want to have a data cell open where I can plug in..lets say 95% under the header of "GOAL", I would like the column next to it to represent a payout based on that variable. So if my Goal is equated by being higher than 95% I would get a 100% payout, and Goal of 94% would get a 94% payout, Goal of 93% would get 93%. As you can see, anything less than 94% gets EVEN payout.
Basically I just need to learn a formula than can have 5 sets or so of criteria.
IF a2>= 95% then payout = 100% and if a2=94% then payout = 94%...etc
I just need to learn how to script what I am thinking in my head LOL
Thanks adam.