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.
- flat rate scheme 1,903 38
- Time to react ? ? ? 236 2
- Guaranteed rents - which is the turnover? 98 1
- which accounts package for busy hairdressers? 107 1
- How much would you charge for an interim audit? 629 9
- Anyone else experiencing issues with sage 50 payroll 107 3
- Company Share Buy Back 107 2
- Charitable Payment 205 4
- Are any of you members of The Institute of Financial Accountants - Accountnats certificate 923 15
- Unpaid share capital 248 3
- Company car in the LLP 171 2
- Physiotherapy 337 4
- New build property to be rented 159 4
- Are you going to Tick and Bash on 21 May? 1,881 52
- Hello 357 2
- Sage 200 question 109 1
- Spanish Assets taxation - UK Residence 101 2
- Ltd Co and Fully Paid Shares 168 5
- RTI and Advances to Employees 174 3
- Sorry - another PPR question 214 4