Excel Formula Help

Lynn S
Lynn S Registered Posts: 13 New contributor 🐸
Hi

Can anyone help me with an excel formula i've been trying to do. I have two columns of figures and wish to put the lower of these in a 3rd column

A B C

1 24.5 36.9 ?
2 48.3 23.4 ?

So i want a formula that states if A1 is less than B1, c1=A1, and if A1 is greater than B1, C1=B1.

Hope that all makes sense, I know what I mean lol

Thanks
Lynn

Comments

  • sab2905
    sab2905 Registered Posts: 3 New contributor 🐸
    Re Excel Help

    In C1 =if(a1<b1,a1,b1) is what you need!

    Good luck

    Sara
  • Ed1
    Ed1 Registered Posts: 51 Regular contributor ⭐
    For Column C, enter the following formula and drag down:

    =IF((A1<B1),A1,B1)

    Hopefully should do the trick.

    Edit: Sab beat me to it.
  • Lynn S
    Lynn S Registered Posts: 13 New contributor 🐸
    Thanks very much for that, it works. You have both saved me a lot of time and effort.

    Thanks again
    Lynn
  • oakley
    oakley Registered Posts: 73 Regular contributor ⭐
    =min(a1:b1)
  • PGM
    PGM Registered Posts: 1,954 Beyond epic contributor 🧙‍♂️
    oakley wrote: »
    =min(a1:b1)

    I used to use the if function, but this is easier for that purpose, especially when you're wanting the lowest figure for a cash flow etc
Privacy Policy