Ask Question
19 December, 04:15

Edit the formula in cell D2 so the references to cell C2 will update when the formula is copied, and the reference to cell B9 will remain constant. Use AutoFill to copy the formula to cells D3:D6.

+2
Answers (1)
  1. 19 December, 05:20
    0
    formula = C2 + (C2*$B$9)

    Explanation:

    given data

    Edit the formula in cell = D2

    references formula to cell = C2

    reference to cell constant = B9

    solution

    we use here for Auto fill to copy the formula to the cell D3:D6 is express as

    Auto fill to copy the formula = C2 + (C2*$B$9) ... 1

    and then we will grab little square on the bottom right and drag it to D6
Know the Answer?
Not Sure About the Answer?
Find an answer to your question ✅ “Edit the formula in cell D2 so the references to cell C2 will update when the formula is copied, and the reference to cell B9 will remain ...” in 📘 Computers and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers