# 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

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)

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>

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

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!

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1