Hi Jayelon
In cell B8, create a formula without using a function that multiplies the value in cell B7 by the value in cell B6 and then adds the value in B7. In this formula, use a mixed reference for cell B6 by including an absolute reference to row 6.
in cell B8, type =(B7*B$6)+B7
Josephine S.
Because I tried it and that's what occurred.
Report
10/25/21
Julie P.
tutor
What values are in your cells? Are you sure you have not made a typo ?
Report
10/25/21
Wyzant A.
Thanks! worked for me
Report
03/26/22
Deardra W.
Worked for me too!!!!!!! Thanks!
Report
04/10/22
Crystal B.
THNAK YOU SO MUCH!! I could not get this one.
Report
01/31/23
Amber S.
Applied f4 to "B6" so it made the entire cell an absolute reference ($B$6) rather than (B$6) which is only to the row. Wish I could just READ, hah
Report
04/07/23
Josephine S.
Do you know why it comes up as !VALUE, and then displays an error symbol?10/25/21