excel

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Low Priority · Version 2010

Nicola has attended:
Excel Introduction course
Excel Intermediate course

Excel

How to add & then multiply

RE: excel

Hi Nicola, thanks for your query. You can use your basic maths operators and cell references to add and then multiply, as so:

=A1+A2*A3

Remember the rules of BODMAS apply, so the multiplication will be carried out first in this example.

Hope this helps,

Anthony


 

Excel tip:

Closing Multiple Open Worksheets At Once

When multiple Excel worksheets are opening, rather than performing a File > Close menu option multiple times, hold down the the SHIFT key and select the File > Close All menu option.

Close All menu option is only displayed when Shift key is down

View all Excel hints and tips


Server loaded in 0.11 secs.