Problem with dragging formulas on spreadsheet

Vítor de Almeida Brito shared this question 4 years ago
Answered

I have made a formula in the spreadsheet, and it correspont to values on points

but when I drag the formula down, it only drag the values of the next points of the formula as it was when it was dragged down, so when I change the value, onlye the formulas I made manually accept the value, and the cells that I have dragged down stays with the same value

Comments (1)

photo
1

please


type A in A1

type A1+B-A in A2

select cell A2

drag down the little blue square at right-down of the selection rectangle

only cells in formula are update the numbers 1,2,3 ........ not

© 2023 International GeoGebra Institute