1 / 4

MICROSOFT EXCEL

MICROSOFT EXCEL. CALCULATIONS. CALCULATIONS: rules. 1. A formula must always begin with an equal sign (they will also work with a + or – sign but an equal sign is preferred). As soon as you begin a cell with a = Excel will know that you are creating a formula. CALCULATIONS: rules.

jenn
Download Presentation

MICROSOFT EXCEL

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MICROSOFT EXCEL CALCULATIONS

  2. CALCULATIONS: rules 1. A formula must always begin with an equal sign (they will also work with a + or – sign but an equal sign is preferred). As soon as you begin a cell with a = Excel will know that you are creating a formula.

  3. CALCULATIONS: rules 2. A formula will follow the order of operations (BIMDAS). Generally if there is more than one part to a formula the calculations will work from left to right but… Any part of the formula in brackets will be calculated first. Indices will be left. Multiplication and division will be next. Addition and subtraction will be calculated last. • B Brackets ( ) • I Indices ^ • M Multiplication * • D Division / • A Addition + • S Subtraction -

  4. CALCULATIONS: rules 3. A formula can refer to other cells in the spreadsheet using cell references.

More Related