View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tmac
 
Posts: n/a
Default 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