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

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

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

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