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