> #range , #formulas , #excel > Formula of finding range using excell?
Nov 20, 2023

Formula of finding range using excell?

1 view
1 view

1 answer

Sort By
Nov 20, 2023
To find the range using Excel, you can use the following formula:

=MAX(range) - MIN(range)

Here, "range" refers to the range of cells containing the data for which you want to find the range. For example, if your data is in cells A1 to A10, the formula would be:

=MAX(A1:A10) - MIN(A1:A10)

This formula subtracts the minimum value in the range from the maximum value, giving you the range of the data.
Ask an expert
Tímea Nagy Ask
Horse trainer, Event organizer, Tour guide, Advertising organizer, Economist
Ferenc-Istvan Vigh Ask
Software engineer, Consultant

Similar Questions


© 2024 - Quanswer