alsmith --
I'm not sure what you're trying to accomplish, but howze about:

A B C
1 # =round(A1,0) =B1-A1

or you might want to make C1 = -(B1-A1) so that rounding up shows a negative
availability.

HTH

"alsmith" wrote:

simple spreadsheet which allocates numbers of duties depending upon number of
employees, allocations always need rounding up or down. I can do this but
need to put remainder ( i.e between -0.49 and +0.49 into a new cell in order
to carry forward to the next round of alocations) any ideas?