Excel formula help please

Poodle
Poodle Registered Posts: 695 Epic contributor 🐘
edited June 18 in AAT member discussion
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

  • Toffeemadblue
    Toffeemadblue Registered Posts: 98 Dedicated contributor 🦉
    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
    Poodle Registered Posts: 695 Epic contributor 🐘
    Hi Toffeemadblue

    Thank you for your help and that does as required.

    I forgot about a clustered if statement :blushing:

    Poodle
  • martin1971
    martin1971 Registered Posts: 6 New contributor 🐸
    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.

Categories

Privacy Policy