Need help with formula translation please
 

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.

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.

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"Michael Saffer" wrote in message
...
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.