Forum Discussion
Excel cell number auto fill
Hi, Kindly assist me with the formula excel use to calculate a figure when you highlight more than one cell with numbers, and drag it, you get an auto calculated number, example Cell: B1,C1, and ...
Excel uses linear extrapolation: it calculates the straight line that best fits these values:
You can return the value 610 using the formula =TREND(B1:D1,{1,2,3},4)
Thank you very much