# Formula to select the highest number, and the lowest and find out the range

1. ## Formula to select the highest number, and the lowest and find out the range

Hello,
I need to create a formula that analises 5 cells and chooses the highest and the lowest number in them, and finds out the differance between them ... how do i do that?

Regards
Dimitry  Register To Reply

2. ## Re: Formula to select the highest number, and the lowest and find out the range

eg
=max(a1:a5)-min(a1:a5)
or even
max(a1,b3,c8,g1,h2)-min(a1,b3,c8,g1,h2)  Register To Reply

3. ## Re: Formula to select the highest number, and the lowest and find out the range

Hi Nero,

use below formula:-

Formula:  `Please Login or Register  to view this content.`

Regards,
DILIPandey
<click on below * if this helps>  Register To Reply

4. ## Re: Formula to select the highest number, and the lowest and find out the range

If in cell A1 your first no. is there and in A2 second and so on...
then the formula will be =(MAX(A1:A8)-MIN(A1:A8))
Regards
Avinesh  Register To Reply

5. ## Re: Formula to select the highest number, and the lowest and find out the range Originally Posted by martindwilson eg
=max(a1:a5)-min(a1:a5)
or even
max(a1,b3,c8,g1,h2)-min(a1,b3,c8,g1,h2)
Eeeepic!! the second one worked like a charm!
Thank you very much!  Register To Reply