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 Best 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 ID.