Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help calculating formulars
I am trying to create a formular to determine the percentages for bonus on funds raised comparing to the goal by each individual. Example: goal was $1700 and $1075 was raised. Goal wasn't met at 100% but 75% was met. 10% will be bonus if goal was met, 7.5% if 75% of goal is met, and 5% if 50% of goal is met. I hope I have explained this well enough. Thanks for all help received. tmac -- tmac ------------------------------------------------------------------------ tmac's Profile: http://www.excelforum.com/member.php...o&userid=33890 View this thread: http://www.excelforum.com/showthread...hreadid=536683 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help calculating formulars
Hi!
goal was $1700 and $1075 was raised. Goal wasn't met at 100% but 75% was met. 1075 is 63.24% of 1700. So, is there no bonus for up to 49% of goal? A2 = 1700 B2 = 1075 =IF(AND(ISNUMBER(A2),A20),B2*IF(B2=A2,0.1,IF(B2 =A2*0.75,0.075,IF(B2=A2*0.5,0.05,0))),0) Biff "tmac" wrote in message ... I am trying to create a formular to determine the percentages for bonus on funds raised comparing to the goal by each individual. Example: goal was $1700 and $1075 was raised. Goal wasn't met at 100% but 75% was met. 10% will be bonus if goal was met, 7.5% if 75% of goal is met, and 5% if 50% of goal is met. I hope I have explained this well enough. Thanks for all help received. tmac -- tmac ------------------------------------------------------------------------ tmac's Profile: http://www.excelforum.com/member.php...o&userid=33890 View this thread: http://www.excelforum.com/showthread...hreadid=536683 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help calculating formulars
Thanks a million! Thanks for correcting my calculation - I was guessing when I typed so I was wrong!! There was no incentive if they didn't reach 50% of goal. We actually was leaning toward 100% participation and that didn't happen. I am learning on formulars so thanks so much for helping out. Another question? Once answer is received how can the formular be edited to have $amount result into correct percentage column? Goal Reached Incentive 10% 7.5% 5% B3 C3 D3 E3 F3 G3 -- tmac ------------------------------------------------------------------------ tmac's Profile: http://www.excelforum.com/member.php...o&userid=33890 View this thread: http://www.excelforum.com/showthread...hreadid=536683 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help calculating formulars
Hi!
If I understand what you want: Goal.....Reached.....Incentive.....10%.....7.5%... ..5% 1700......1075..........53.75..................... .............X 1700......1300..........97.50..................... .X............ 1700......2000...........200............X......... ............... 1700.......849..............0..................... ................... Enter this formula in E3 and copy across to G3: =IF($D30,IF($D3/$C3=E$1,"X",""),"") Biff "tmac" wrote in message ... Thanks a million! Thanks for correcting my calculation - I was guessing when I typed so I was wrong!! There was no incentive if they didn't reach 50% of goal. We actually was leaning toward 100% participation and that didn't happen. I am learning on formulars so thanks so much for helping out. Another question? Once answer is received how can the formular be edited to have $amount result into correct percentage column? Goal Reached Incentive 10% 7.5% 5% B3 C3 D3 E3 F3 G3 -- tmac ------------------------------------------------------------------------ tmac's Profile: http://www.excelforum.com/member.php...o&userid=33890 View this thread: http://www.excelforum.com/showthread...hreadid=536683 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating time | Excel Discussion (Misc queries) | |||
Calculating Cells n% displayed in a cell? | Excel Worksheet Functions | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | Excel Discussion (Misc queries) |