Im trying to create a formula to calculate bonuses for my employees and I cant figure it out.*
Here is what im trying to do.
One cell to state:
(specs $30,000-$50,000 @ .5%)
I need this cell to calculate .5% for the total from cell C13 if total is from $30K-$50K
And another cell to state:
(specs $50,001+ @ 1%)
I need this cell to calculate 1% for the total from cell C13 if total is from $50001 and above
Can anyone help? I will be so greatful! Thank you!
Bookmarks