Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

formula

ResolvedVersion 2007

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

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

Excel tip:

Change Excel's default font

You can change the default font and font size for all spreadsheets created in Excel by:

1. Going to Tools on the menu bar.
2. Select Options, then General.
3. Next to Standard Font you can change the font and font size.
4. Click OK.

Each new file you start from this point onward should use the font and font size you have selected.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 1.04 secs.