OK, i have tried at this for hours and got know where.

i have set up a simple worksheet for my businesses bonuses and does the
workings out for each employee etc.

It is split up into month by month.

So say January there is £20,000 then the bonus will be 1.6% of that amount
and seperated between 4 people.

However, the £20,000 could also be a -£20,000. Now if it is -£20,000 i need
to add it to the following months total. It is is not a negative amount then
they get the bonus.

Hope you can help.

david