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
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
max(your cells)-min(your cells)
eg
=max(a1:a5)-min(a1:a5)
or even
max(a1,b3,c8,g1,h2)-min(a1,b3,c8,g1,h2)
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Hi Nero,
use below formula:-
Formula:
Please Login or Register to view this content.
Regards,
DILIPandey
<click on below * if this helps>
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks