How to calculate rows in excel?

I need each number in row 5 to be divided by 4500 and go to row 6. So, for example, B6 should equal 0.115/4500. Do I have to do this for each box, or can I make one equation for the whole row?

Attachment image

2 Answers

  • 8 months ago
    Favourite answer

    It's easy. Press on B6. Write =B5/4500. Press enter. Then press on the box then drag to the other columns of the raw.

  • Lv 7
    8 months ago

    click B6, and type:


    hit Enter, then select the cell again and drag the bottom right corner to the right.

Still have questions? Get answers by asking now.