Hey Bob -

When doing what you've suggested, an earned bonus of $5881 for March
doesn't calculate as being due, but it should.

The formula should probably have some type of 'if-then-and' that says
if you've hit your current month target, you get your bonus AND any
year to date amount owed. If the year to date (which doesn't look like
it comes into play until June) is positive, you get 3.14% of that
amount. If it's negative there is no detriment, just no add'l bonus.


Make sense? And thanks...

Derek


--
derekblain
------------------------------------------------------------------------
derekblain's Profile: http://www.excelforum.com/member.php...o&userid=37171
View this thread: http://www.excelforum.com/showthread...hreadid=568877