Assuming you want the last column to be the "catch" column, that is it
will either be higher or lower than the other two columns by one if the
number is not divisible by three evenly you can try the following:


Code:
--------------------
Row Col A Col B Col C Col D
11 11 =MROUND(A11,3)/3 =MROUND(A11,3)/3 =MROUND(A11,3)/3-(MROUND(A11,3)-A11)
12 12 =MROUND(A12,3)/3 =MROUND(A12,3)/3 =MROUND(A12,3)/3-(MROUND(A12,3)-A12)
13 13 =MROUND(A13,3)/3 =MROUND(A13,3)/3 =MROUND(A13,3)/3-(MROUND(A13,3)-A13)
--------------------


--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=564899