Many thanks for these replies. The two values were calculated, not input manually.

Yes you are correct I added a poll by mistake - this was my first attempt at a post, so got it wrong.

When I went into this forum today my post was under excel programming, so maybe the website changes things for you?

Is there any way of getting round the floating point arithmetic? I only have one digit after the decimal point so I could split the number into two cells and do two calculations and then put the numbers back together again. This would be very messy, so if anyone knows how to make sure the floating point arithmetic is correct, please let me know.

No, the site doesn't do that of its own accord. Rather, as I said in my previous reply:

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

The article provided proposes solutions ( if you have read it entirely)

BTW using an email address as username is an open invitation for spammers...

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post