Return the Lessor or Greater Value of Cells

[Brabed]

I am trying to find a way to return the lessor value of two cells. I also want the inverse, to be able to return the greater of two cells. I know the answer is probably easy, but it escapes me right now.


Thanks in advance.

 

[NBVC]

This should suffice:

=IF(A1<B1,A1,B1)

and for the inverse

=IF(A1>B1,A1,B1)

 

[joelnichols]

Book1
	C	D	E	F
7		4
8		5	4
9
10
11
12		4
13		5	5
Sheet1

 

[Aladin Akyurek]

I am trying to find a way to return the lessor value of two cells. I also want the inverse, to be able to return the greater of two cells. I know the answer is probably easy, but it escapes me right now.


Thanks in advance.

=MAX(A2:B2)

=MIN(A2:B2)

If the target cells are not next to each other:

=MAX(A2,F2)

=MIN(A2,F2)