Need help with formula translation please

M

Michael Saffer

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.
 
F

Fred Smith

A confusing formula indeed. Even if it was translated, it still might not
solve your problem.

Why don't you post what your problem is, and the solution you are looking
for. That way, you'll get what you need regardless of what this formula
does.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top