CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
n0obcoder
n0obcoder

Reputation: 737

How to drag a formula in google sheet?

enter image description here

I want to divide all the numbers from A63 to A65 with the number in cell A61, and put the results in cells from B63 to B65

How can I achieve this?

Upvotes: 1

Views: 61

Answers (1)

player0
player0

Reputation: 1

use in B63:

=INDEX(A63:A65/A61)

if you still want to drag it use:

=A63/A$61

Upvotes: 1

Related Questions