# Excel Formula Help

Options
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

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

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

Good luck

Sara
• Registered Posts: 51 Regular contributor ⭐
Options
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.
• Registered Posts: 13 New contributor 🐸
Options
Thanks very much for that, it works. You have both saved me a lot of time and effort.

Thanks again
Lynn
• Registered Posts: 73 Regular contributor ⭐
Options
=min(a1:b1)
• Registered Posts: 1,954 Beyond epic contributor 🧙‍♂️
Options
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