I'd really appreciate any help I could get with this. I though I had it a few hours ago, but now I'm googly-eyed, can't think straight, and actually managed to revert back from a function that worker partially to one that doesn't work at all.
At the point where I had half of the formula working, I could continue no further because I received an error message like "too many arguments in this cell". Following is the commission schedule I would like to create function/formula for so all I will have to do in the end is input the gross for the month and get the correct value:
if gross is between:
0-$12,500 - commission is 3%
12,501-15000 - commission is 4%
15,001-17,500 - commission is 5%
17,501-20,000 - commission is 6%
20,001-22,500 - commission is 6.25%
22,501-25,000 - commission is 6.5%
25,001-∞ - commission is 6.75%
this is what is left of the butchered work I've been wasting the last several hours trying to get to work ... again, any help would be appreciated.
=IF(C8<=12500,(C8*0.03),IF(C8>=12501),AND(C8<=15000,(C8*0.04))
Thanks in advance.
Bookmarks