Hello everybody,



Two people from a google forum helped me with an expense problem similar to
this. This one is all about revenue. Thanks to those people if you're
watching!





I found this formula and it works within a spreadsheet that will show a
percentage of an available bonus to pay an employee who meets a revenue
goal providing certain criteria is met. It looks to me like some
percentages are meant to show return text, like "30%" in the second nested
if, while other percentages like "70%" in the same second nested if are used
for division. Then in the third nested if, it looks like the author used a
combination of percentages that is confusing me, like 100% and /50% and
1.5. I'm not sure what is actually going on here.



Here's the formula:



=IF((R14<H14),0,IF(R14<J14,30%+((R14-H14)/((J14-H14)/70%)),IF((100%+((R14-J1
4)/((L14-J14)/50%))1.5),150%,100%+((R14-J14)/((L14-J14)/50%)))))



R is Actual

H is 95% of Budget

J is Budget

L is 110% of Budget





Does anyone have the time to actually type this formula in English? If I
could read in English what this formula is doing, I could understand it a
lot better and also be very grateful.



As always,

Thank you for your time and patience.



Regards,

Michael

Jacksonville.