Excel formula help please

Poodle

Hi

Does anyone know what formula I would enter into a cell to enable the return of the leser value of two other cells?

EG

A1= 15
A2 = 20
A3 would take a formula to return the value of 15

Poodle

Toffeemadblue

Hi poodle,
=IF(B1>A1,A1,B1)
Should do the trick the only issue is what you want to do if they are equal, this formala will return the equal value
:001_smile:

Poodle

Hi Toffeemadblue

Thank you for your help and that does as required.

I forgot about a clustered if statement :blushing:

Poodle

martin1971

Or you can use

"=min(number1, number2, ...)"

You can also reference ranges, names i.e.

=min(A1:A10) will return lowest number in range A1:A10

Empty cells are ignored.