-
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules