Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |