This may be a start, I have only put the bonus as an amount, not
multiplied it by a fixed percentage. A slight isssue is If I have
exceeded performance and budget in month 1 but then failed in month 2,
can I get bonus in Month 2 if my year to date performance is still an
improvement on the previous year, in this example I have assumed you
do

Regards

Dav


+-------------------------------------------------------------------+
|Filename: Bonus.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5167 |
+-------------------------------------------------------------------+

--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=569657