Why not post the file here, it can appear as a zipped attachment.

If a person is under the previous years performance for the first 2
month, say $50000 on month 1, $100000 on momth 2 and they exceed the
budget by $125000, in month 3, what would you wish to happen?
Pay the bonus on $125000 as previously you were $150000 behind?

Or something else

Regards

Dav


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