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