1 / 13

FORMULAS AND FUNCTIONS IN EXCEL

FORMULAS AND FUNCTIONS IN EXCEL. Mrs. Brownfield Smith-Cotton High School Sedalia, MO. FORMULAS. A mathematical operation performed in a spreadsheet Can be entered directly in the cell Can be entered in the formula bar. FORMULAS. All formulas must start with the equal sign =

briana
Télécharger la présentation

FORMULAS AND FUNCTIONS IN 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. FORMULAS AND FUNCTIONS IN EXCEL Mrs. Brownfield Smith-Cotton High School Sedalia, MO

  2. FORMULAS • A mathematical operation performed in a spreadsheet • Can be entered directly in the cell • Can be entered in the formula bar

  3. FORMULAS • All formulas must start with the equal sign = • Then add your mathematical operation • Type enter to add the formula in the desired cell

  4. FORMULAS • Make sure cell D3 is selected • Always start with the = • Then add the cells and operators • =A4/(A1+B3+C2) Example: Enter a formula in cell D3 that divides cell A4 by the sum of cells A1, B3, and C2.

  5. FUNCTIONS • Also mathematical operations • Specific to an operation needed • Examples: • SUM (adds) • AVG (averages) • MIN (Finds minimum number) • MAX (Finds maximum number)

  6. FUNCTIONS • Click to make cell A8 active • Type AVERAGE • Click to make cell C8 active • Type the = • Type AVERAGE(C2:C6) • AVG is the function you want to perform • (C2:C6) is the range you want to apply the function to

  7. IF FUNCTION • Logical Test • Example: If it rains, I will take my umbrella • If I have $20 I will save 10%, but if I have more than $20 I will save 15%

  8. IF FUNCTION How does this work in Excel? If I have $20 I will save 10%, but if I have more than $20 I will save 15% Step 1 – Click to activate cell C2

  9. IF FUNCTION Step 2 – Go to INSERT - FUNCTION Step 3 – Click on IF and Click OK

  10. IF FUNCTION Step 4 – Enter your test and answers If B2 is less than or equal to 20, then multiply B2 by 10%, if not, multiply B2 by 20%

  11. IF FUNCTION • Step 5 – Your formula should be entered, now copy it to cells C3 through C8 • Click and hold the tiny black box (Fill Handle) • Drag it down to the bottom of C8 and let go

  12. IF FUNCTION Your final product should look similar to this! Yeah, it calculated the savings for you!

  13. FORMULAS & FUNCTIONS • Formulas • Mathematical operation • Always start with the equal sign • Follow order of operations • Functions • Specific mathematical operation • Always start with the equal sign • Use function command, parenthesis, and cell ranges

More Related