![]() |
|
#1
|
|||
|
|||
|
All, I attach (I hope) a very simple petty cash spreadsheet. All entries are either values in GBP and pence - ie only to two places; or additions and subtractions, which should, logically, be limited to two places. None of the entries are caused by division (or multiplication), which could cause values beyond the two places.
I have expanded the column width to show many places of decimals. Can anyone explain why Excel gets its sums wrong? (And then appears to correct itself.) And what can I do about it? Thanks Richard 0 Petty Cash 2015 Mk II.xlsx |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Tiered Fee Calculations
|
lynchbro | Excel | 5 | 07-17-2014 11:01 AM |
Financial Data Organization
|
captain_hawkeye | Excel | 1 | 06-14-2010 04:09 AM |
Federal financial rounding?
|
markg2 | Excel | 6 | 05-26-2010 09:54 AM |
| Formatting financial ratios | jtrobinson | Word | 0 | 01-19-2010 06:46 AM |
Can I do calculations with times?
|
cubsfan_1 | Excel | 1 | 01-14-2010 06:55 PM |