excel formula

imported_Anonymous · Feb 13th 2003

I would like to know how to write a formula that will pick the greatest value from 5 other cells

Dave Hawley · Feb 13th 2003

Hi Anonymous

Welcome to the board.

The Max or Large Functions will do this, eg

=MAX(A1:A100)
=LARGE(A1:A100,1)

will both return the largest number in the range A1:A100. The Large function can be used to return the largest, 2nd largest, 3rd largest etc by changing it to
=LARGE(A1:A100,1)
=LARGE(A1:A100,2)
=LARGE(A1:A100,3)
etc

excel formula

Participate now!

Share