When a formula has multiple arithmetic signs, Excel follows an order of priority in performing calculations. Excel multiplies and divides before it performs addition and subtraction. Parentheses should be used to indicate calculations that should be performed first. Get it right, use parentheses to indicate how calculations should be performed. For example, the formula for year one straight-line depreciation expense is =(5100-300)/5 . |
This formula indicates that the $300 salvage value is subtracted from the $5100 cost first, and then that new amount is divided by 5.
The formula 5100 - 300/5 equals 5040 and not 960.
|DSS Home | About Us | Contact Us | Site Index | Subscribe | What's New|
Copyright © 1995-2013 by D. J.
Power (see his home page).|
DSSResources.COMsm is maintained by Daniel J. Power. Please contact him at email@example.com with questions. See disclaimer and privacy statement.