Question: what is the range formula in excel?
Answer: Type "=MAX(A2:A20)-MIN(A2:A20)" to find the range in a single step. This tells Excel to find the maximum of the data and then subtract the minimum of the data from it.