Excel formula help please

PoodlePoodle Experienced MentorPosts: 711Registered
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

Comments

  • ToffeemadblueToffeemadblue Well-Known Posts: 102Registered
    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:
  • PoodlePoodle Experienced Mentor Posts: 711Registered
    Hi Toffeemadblue

    Thank you for your help and that does as required.

    I forgot about a clustered if statement :blushing:

    Poodle
  • martin1971martin1971 New Member Posts: 6Registered
    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.
Sign In or Register to comment.