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