Selecting the greater (or lesser) of 2 values

D

djm

I am looking for a formula that will compare 2 values and select th
greater (or, in some cases, the lesser) of the 2 values...I have use
things like =If(a1>d1,a1,d1) etc etc but wonder if there is somethin
that is a bit more flexible...??.....any suggestions, anyone
 
R

RagDyer

Try Min() and Max()

=MIN(A1,B1) for the smaller
=MAX(A1,B1) for the bigger

Also:
=MIN(A1:A5,B1:B5)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I am looking for a formula that will compare 2 values and select the
greater (or, in some cases, the lesser) of the 2 values...I have used
things like =If(a1>d1,a1,d1) etc etc but wonder if there is something
that is a bit more flexible...??.....any suggestions, anyone?
 
Top