FORMULAS AND FUNCTIONS IN EXCEL

FORMULAS AND FUNCTIONS IN EXCEL

FORMULAS AND FUNCTIONS IN EXCEL

- - - - - - - - - - - - - - - - - - - - - - - - - - - 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