Forum Discussion
Help with formaulas
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.
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.
