Simple Excel problem with rounding
In Excel if I have a formula in each of three cells (say, B1, B2 and B3), let's say B1 has =A1/3, B2 has =A1*2, and B3 has =A1.
Say in A1 I have 4.2.
Then B1, B2 and B3 evaluate to 1.4, 8.4 and 4.2 respectively.
Then =sum(B1:B3) evaluates to 14.
Suppose then I set my viewing options to display only whole numbers.
I then have 1+8+4=14.
Other users of my spreadsheet will spot what appears to be an obvious error!
I could avoid this by laboriously amending the formula in each of the cells to =round([formula],0).
I would then have a different result 1+8+4=13 which at least doesn't 'look wrong' on screen.
But changing the formulae in each of the cells B1 to B3 is a pain! And what if I have a spreadsheet with hundreds of formulae?
Is there an easy way to make sure a spreadsheet which shows figures in round pounds, or round thousands, or round millions, can be made to look as if at least I can add up correctly!!
I am sure this must have been asked before.
- property capital gains 151 2
- Transferring DLA between Directors 140 1
- Private doctors - Ltd company vs partnership 1,160 13
- Tips on meals 180 2
- Buy Samsung Galaxy Note 5 516 10
- Rental losses on jointly owned property 159 3
- Personal Tax 727 13
- Overpaid In Employers NI - RTI EYU for hundreds of employees 179 2
- Stumped - IHT 143 2
- Leaving the VAT FRS Scheme or trying to stay as long as possible? 410 6
- No PAYE Registration but need auto enrolment 473 11
- HMRC now overriding SA bank repayment details on tax returns 1,283 33
- Credit management tools 146 1
- Write an article on latest tax changes for landlords. 771 20
- Incorporate to utilise dividend allowance next year? 402 7
- CGT and primary residence 180 1
- Marriage Allowance 278 3
- S455 and February year ends 334 7
- HMRC having technical difficulties 891 18
- Closing down loss-making company 460 5