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

excel consulting - formulae

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel consulting - Formulae

excel consulting - Formulae

ResolvedVersion Standard

Rosemary has attended:
No courses

Formulae

Do I need to put brackets in the formula when I'm doing an addition i.e. =(45+78)

RE: formulae

Hi Rosemary,

Thanks for the question.

No you do not need to use brackets, but remember the computer uses the BODMAS order, brackets, Division, Multiplication, Addition, Subtraction. So 3+4*2 will be 11 because it will do the multiplication first, if you don't want this to happen you can put brackets in, so (3+4)*2 =14

Hope that helps

Tracy

Excel tip:

Add Text to Displayed Numbers in Excel 2010

To add text to a number in a cell, you need to go to the Home tab on the Ribbon, and click on the Cells group. Select Format Cells from the drop down menu then Custom from the Category list. In the Type box select General. After the word General, enter a space, then opening quotation marks, then the word you want to type and then closing quotation marks. Click on OK and you have your text!

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 0.1 secs.