I’ve got a problem related to rounding money up/down.

I have an invoice amount that I enter into a cell and it needs to be split three ways, like so:

57.55%
14.39%
28.06%


Let’s take for example this one for £3447.36 (it’s in C3)

I’ve made three cells reference that and divide it accordingly:


=(C3/100)*57.55
=(C3/100)*14.39
=(C3/100)*28.06

It gives me
£1,983.96
£496.08
£967.33

But if you add those three numbers up it comes to £3447.37

That’s a penny too much!

I presume I need to change my formula, but I don’t know how.

The woman whose job I got split it as:
£1983.96
£496.07 there’s your rogue penny
£967.33

Which obviously totals £3447.36.

But she worked on paper (and presumably a calculator) cos she was a biddy.

Help me out?