I am trying to create a formula based on these 2 variables in the attached example. I need to solve for column "J" the "Bonus" based on the parameters given.
Example formula.jpg
I am trying to create a formula based on these 2 variables in the attached example. I need to solve for column "J" the "Bonus" based on the parameters given.
Example formula.jpg
how about =IF(E4<=30%,H4*.06,if(E4<=40%,H4*.08,IF(E4<=45%,H4*.11,IF(E4<=55%,H4*.14,H4*.15))))
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Try this.
=H4*LOOKUP(E4,{0,0.31,0.41,0.46,0.56},{0.06,0.08,0.11,0.14,0.15})
If posting code please use code tags, see here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks