Function to Compare Two Cells and Return the Smaller in Excel -


I thought that something like this would happen in Excel because it looks very basic ... but:

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

  = IF (A1> A2, A2, A1)  

But a complex In the formula, it seems unnecessary unnecessary.

It is also possible to do this with:

  = small (A1: A2)  

But of course my Cells are not adgent and do not make a limit.

Thoughts?

you want to use


Comments