You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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
Question marked as Top-ranking reply

Posted on Oct 8, 2021 5:58 AM

Hi JetteApparel,


Use the ROUND function on the calculated VAT



Formula in B2: ROUND(A2×0.2,2)


Regards,

Ian.

Similar questions

2 replies

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.