Selecting the greater (or lesser) of 2 values

[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

 

[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?

 

[Leo Heuser]

One way:

=MIN(A1,D1)

=MAX(A1,D1)