I thought I had rounding sorted until this one.
The green numbers add up to £116.55
£47.16      is   £47.157  so ok it rounds to £47.16
£41.16     is    £41.156  as does this  to    £41.16
£24.63     is    £24.630 and does not need to round

however the 3 amounts don't add up they are a penny
short. I think I have tried everyway possible to get that

Total to   = £116.56

I'm stumped any ideas please.

Rita

Rita,

Instead of adding the values, add the rounded values:
round(v1,2) + round(v2,2) + round(v3,2)
instead of
round(v1 + v3 + v3 , 2)

After all, that's what you are showing, the rounded values, not the real values.
--
Fernando Dias
[Team Elevate]

Rita


I think you're losing it. Its not the adding up that's wrong

£47.16 + £41.16 + £24.63 = £112.95

Your jpg and what you've posted aren't the same. Why did you post £24.63 and the jpg show £28.24?

With all the above Fernando's probably right - add the rounded values.

Roy Lambert [Team Elevate]

Ro
> I think you're losing it. Its not the adding up that's wrong
>
> £47.16 + £41.16 + £24.63 = £112.95
>

And you think I need neew glasses

John

Roy

In fact with Rita and I there might be a business opportunity

John

John


Ever heard of SpecSavers?

Roy Lambert

Hi Rita,

You have obviously copied the wrong value into the last value, but even
so with the full values of

 47.157
 41.156
 28.240
========
116.553
========

This would round to 116.55

and with the rounded unit values:

 47.16
 41.16
 28.24
========
116.56
========

So it depends upon where you are doing the rounding, in your case it
looks like you should round the unit values first (as that is what you
are displaying on the screen) and add them together last.

Chris Holland


On 10/04/2011 21:32, Rita wrote:
> I thought I had rounding sorted until this one.
> The green numbers add up to £116.55
> £47.16 is £47.157 so ok it rounds to £47.16
> £41.16 is £41.156 as does this to £41.16
> £24.63 is £24.630 and does not need to round
>
> however the 3 amounts don't add up they are a penny
> short. I think I have tried everyway possible to get that
>
> Total to = £116.56
>
> I'm stumped any ideas please.
>
> Rita

--
Chris Holland
[Team Elevate]

Thank you Sir.
Rita

He probaly is right then he took the time to try and understand
rather than poke fun at my bad eyesight. Funny thing tho I
just bought a pair of them over the counter specs for reading
and they work £3 quid nice
Rita

]

Indeed "Bins are us" would be a good name.
Rita