Forum Discussion

Leeanna91's avatar
Leeanna91
Copper Contributor
Mar 03, 2023
Solved

Help with formaulas

Hello my fellow Excel community, I am in a pickle and need some help, please. I am a student at Front Range Community College, and my assignment is excel module 3 Performing calculations with formals...
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Mar 03, 2023

    Leeanna91 Without doing the assignment for you I can help you on your way with number 4. The others are quite similar.

     

    You're not allowed to use functions like PRODUCT or SUM, so you're limited to the operators like *,  /, + and - . You wouldn't want to use functions anyway for such basic calculations.

    So, that formula would be:

    =B7*B6+B7

     

    Now, the instruction says to make the row in B6 absolute. Absolute references are made by putting $ signs in front of the column or row reference or both. It will fix the reference so that it doesn't change when copying and pasting the formula. For instance, $B$6 will fix both the column and the row. In your case, you need to use B$6 to fix just the row.

Resources