Question: what is the excel formula for range?
Answer: Fill several rows with the values you want to calculate the range for. At the bottom of the column, type the following formula =MAX (Axx:Ayy), where Axx and Ayy are the starting, and the ending cells of your data, respectively.