If you mean to find the difference between the highest and lowest number in a set, then you could use the MAX and MIN forumulas to find the two values and take the lowest from the highest. So if your values were in cells A2 to A20 then the formula would be:
=MAX(A2:A20)-MIN(A2:A20)
Your welcome
range finder
There is no single formula. MIN(range) and MAX(range) are the Excel formulae
There are several functions of Excel that do not work with 3D formulas. These include cell references and range formula.
If your data range is a1:a10 then the interquantile range equation is =percentile(a1:a10,0.75)-percentile(a1:a10,0.25)
It allows you to quickly fill a range of cells with some data or a formula.
Range finder. Double clicking on the formula activates the range finder and you can see what cells are in the formula. This can help you see if the correct cells are in the formula.
=SUM(X1:X10)
The Range Finder feature is enabled when a user creates a new formula or edits an existing formula. The Range Finder gives users better visual feedback for moving and resizing the Range Finder range. You can see the ranges included in the formula are highlighted by different color border lines.
It can simply be a range. It could also be an array. It will depend on the formula itself.
range finder
The first key you type in Excel to create any kind of formula is the equal sign (=). If you are trying to create an array formula press CTRL+SHIFT+ENTER. Excel surrounds the formula with braces ({ }) and places an instance of the formula in each cell of the selected range.
MAX. If you had a series of numbers in the range B1:B84 the following formula would show the largest of them: =MAX(B1:B84).