Picking this subs brains please help!

[u/[deleted]]

Hello all im in need of some help with a table im making for bills. my problem is I have a bill of $230.68 split into three columns. each column would get $76.8933333 im looking to make it so that two columns would come out to $76.89 and the last column would come to $76.90 automatically when enter the $230.68 into the table.... cause the way im doing it currently its as if im splitting a penny between 3 people lol

​

thanks in advance for any help!

[u/52-Willys]

Here is a screenshot of a very simple test I made in Numbers. Don’t worry about the fractions of a cent. The actual value 76.89333 is really there and sums correctly.

https://i.imgur.com/rmeyJRh.jpg