User Profile
mah2023
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Bonus calculation in Excell
What is the formula for calculating the branch bonus with the following assumptions? 1- Goal of obtaining resources: 1000000 2- No reward will be given to 15% of the attracted resources. 3- Amount of reward: 0.1% of attracted resources after deducting the amount of row 2. 4- The goal of attracting resources in 4 account categories is as follows: 35% of the first category, 30% of the second category, 25% of the third category, 10% of the fourth category. Rewards will be calculated according to these percentages. 5- If the amount of resources absorbed in a group is more than the target amount, provided that group is higher than one group(at least), the difference of the absorbed coefficient compared to the target coefficient in the lower group will be added to the upper group.314Views1like0CommentsRe: Help with #NUM error in IRR formula
JoeUser2004 hi- Thank you for your explanation Information : Excel 2016 -device: pc (desktop)- File: It is the same as the initial file. I know the basics of working with Excel, such as formatting and... (wink). My main question: When I enter the yield formula into the cell it gives NUM error. Why should I reduce the unit (divide by 1,000,000) when the cash flow amounts are the same numbers? (see attach file- sheet IRR2)25KViews0likes3Comments- 25KViews0likes13Comments
Re: Help with #NUM error in IRR formula
I have the same problem. please check the table and help me. cash flow 1372000000000 1 0 2 (77777777778) 3 (73009451097) 4 (68241124416) 5 (63472797735) 6 (58704471055) 7 (53936144374) 8 (49167817693) 9 (1416399491012) 10 (39631164332) 11 42914940127 12 42914940127 13 42914940127 14 42914940127 15 40076609987 16 37238279847 17 34399949707 18 31561619568 19 28723289428 20 25884959288 21 23046629148 22 20208299008 23 17369968868 24 17369968868 25 17369968868 26 17369968868 27 15439972327 28 13509975786 29 11579979246 30 9649982705 31 7719986164 32 5789989623 33 3859993082 1929996541 IRR #NUM!25KViews0likes15CommentsRe: Help with #NUM error in IRR formula
hasan ahmed I have the same problem. please check the table and help me. cash flow 1372000000000 1 0 2 (77777777778) 3 (73009451097) 4 (68241124416) 5 (63472797735) 6 (58704471055) 7 (53936144374) 8 (49167817693) 9 (1416399491012) 10 (39631164332) 11 42914940127 12 42914940127 13 42914940127 14 42914940127 15 40076609987 16 37238279847 17 34399949707 18 31561619568 19 28723289428 20 25884959288 21 23046629148 22 20208299008 23 17369968868 24 17369968868 25 17369968868 26 17369968868 27 15439972327 28 13509975786 29 11579979246 30 9649982705 31 7719986164 32 5789989623 33 3859993082 34 1929996541 35 IRR #NUM!25KViews0likes0Comments
Recent Blog Articles
No content to show