Need help calculating formulars

T

tmac

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
 
B

Biff

Hi!
goal was $1700 and $1075 was raised. Goal wasn't met at 100% but 75%
was met.
Click to expand...

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),A2>0),B2*IF(B2>=A2,0.1,IF(B2>=A2*0.75,0.075,IF(B2>=A2*0.5,0.05,0))),0)

Biff
 
T

tmac

Thanks a million!

Thanks for correcting my calculation - I was guessing when I typed so
was wrong!! There was no incentive if they didn't reach 50% of goal.
We actually was leaning toward 100% participation and that didn'
happen.

I am learning on formulars so thanks so much for helping out. Anothe
question? Once answer is received how can the formular be edited t
have $amount result into correct percentage column?

Goal Reached Incentive 10% 7.5% 5%
B3 C3 D3 E3 F3 G
 
B

Biff

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($D3>0,IF($D3/$C3=E$1,"X",""),"")

Biff
 
Top