Use the rounded value displayed in a formla, not the unrounded

I'm creating a stock spreadsheet. I want to see each item's net, vat, total and then multiply that by the number of items in stock so getting a value of what I'm holding. I'm rounding the currency cells to 2dp but when I put the formula for the total cell x the stock count, it uses the unrounded amount and then rounds up e.g.


the forumula i'm using is = total x stock


net vat total. stock value held

£2.52 £0.50 £3.02 2. £6.05. this is what i see on the sheet


so it's actually doing this


2.52. 0.504. 3.024 2 6.048 so then it's rounding up to 6.05



I want it to calculate what is actually displayed (rounded to 2dp)


so £3.02 x 2 = £6.04


how do I achieve this please? - I'm sure it's so simple but I can't seem to do it!


thanks




iMac 27″, macOS 10.15

Posted on Oct 8, 2021 4:08 AM

Reply

Similar questions

2 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Use the rounded value displayed in a formla, not the unrounded

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.