Norman Potting
Well-known member
- Thread starter
- #21
Thanks for all your suggestions - will try later today and report back. Another thought - anyone got a copy of Lotus 123 I could borrow 
Changing the decimal places using the buttons doesn't actually change the value, it just changes how it appears. So if the cell is referenced in another formula, the original non-rounded value is used.How does the ROUND in a formula differ from using the decimal place up or down function?
Asking as an excel user at a rudimentary level
Chaps and chapesses. The winning entries to this thread are those that alluded to the "Round" function, in particular Mr., Mrs. or Ms. "Lets Have A Winner" who has helped me out via a rare post. Thanks to all of you who took the trouble to post your suggestions, I now have a spreadsheet that looks correct and with numbers that agree with me adding them up on a calculator!
The worrying thought is that I would probably have spent far less time knocking up a table in Word and doing the calculations manually![]()