Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-05-2015, 12:47 AM
Richard121 Richard121 is offline Errors in financial calculations Windows 7 64bit Errors in financial calculations Office 2013
Novice
Errors in financial calculations
 
Join Date: Feb 2015
Posts: 10
Richard121 is on a distinguished road
Default Errors in financial calculations

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
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Errors in financial calculations Tiered Fee Calculations lynchbro Excel 5 07-17-2014 11:01 AM
Errors in financial calculations Financial Data Organization captain_hawkeye Excel 1 06-14-2010 04:09 AM
Errors in financial calculations Federal financial rounding? markg2 Excel 6 05-26-2010 09:54 AM
Formatting financial ratios jtrobinson Word 0 01-19-2010 06:46 AM
Errors in financial calculations Can I do calculations with times? cubsfan_1 Excel 1 01-14-2010 06:55 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:57 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft