98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formula
Formula
Resolved · High Priority · Version 2007
Tue 29 Jul 2008, 16:34Delegate Sophie said...
Sophie has attended:
Excel Introduction course
Excel Advanced course
Excel Intermediate course
Formula
=b3+b4+b5*1.5
is the same as=(b3+B4)+B5*1.5
Thu 31 Jul 2008, 15:47Trainer Amanda said...
RE: formula
Hi Sophie
Thank you for your post and welcome to the forum.
The two formulas you have written would give you different results, therefore they are not the same.
In a formula with brackets, things inside the brackets are calculated first, then if there is multiplication or division this is done next; and lastly addition or subtraction.
In the first formula you've written, B5*1.5 is done first (multiplication) then B3 and B4 would be added to this.
In the second formula, B3 and B4 would be added first, then B5 would be multiplied by 1.5, then the results of these two separate calcuations would be added together.
Amanda
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Recovering Unsaved Work in Excel 2010Ever closed your Excel workbook in a hurry without saving your work beforehand? Here's how to get it back. |
