CODEWITHSUNDEEP
excel
aronchick
aronchick

Reputation: 7128

Function to Compare Two Cells and Return the Smaller in Excel

I'd think there'd be something to do this in Excel, because it seems so basic... BUT:

I have two cells and I need to compare them and return the lower of the two. This is very easily done with the following:

=IF(A1 > A2, A2, A1)

But in a complex formula, this seems insanely unnecessary.

It's also possible to do with:

=SMALL(A1:A2)

But of course my cells are not adjecent and don't make a range.

Thoughts?

Upvotes: 2

Views: 57657

Answers (2)

dublev
dublev

Reputation: 4395

The Excel Min function:

=MIN(A1,A2)

Upvotes: 0

VeeArr
VeeArr

Reputation: 6188

You want to use the MIN() function.

Upvotes: 11

Related Questions