Hi
It depends how accurate you need to be. The easiest way would be to
calculate 3 of your values and then get the fourth value by taking the total
of those 3 away from 10.
Hope this helps.

--
Andy.


"Wileycat" wrote in message
...
I am using a spreadsheet that contains a list of hours worked. I need to
apportion the hours worked to a restricted number of hours. For example:
I have 2, 5, 6 & 3. I need the values to be apportioned to a ten hour
period
rounded to two decimal places. When I do this I get values of 1.25, 3.13,
3.75 & 1.88 a total of 10.01

How can I guaratee my adjusted values come back to the predetermined
value, 10