Excel Formula Help
Options
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
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
0
Comments

Re Excel Help
In C1 =if(a1<b1,a1,b1) is what you need!
Good luck
Sara0 
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.0 
Thanks very much for that, it works. You have both saved me a lot of time and effort.
Thanks again
Lynn0 
=min(a1:b1)0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 12.4K For AAT students
 298 NEW! Qualifications 2022
 154 General Qualifications 2022 discussion
 11 AAT Level 2 Certificate in Accounting
 54 AAT Level 3 Diploma in Accounting
 77 AAT Level 4 Diploma in Professional Accounting
 8.8K For accounting professionals
 23 coronavirus (Covid19)
 271 VAT
 92 Software
 271 Tax
 135 Bookkeeping
 7.2K General accounting discussion
 198 AAT member discussion
 3.8K For everyone
 38 AAT news and announcements
 345 Feedback for AAT
 2.8K Chat and offtopic discussion
 581 Job postings
 16 Who can benefit from AAT?
 36 Where can AAT take me?
 42 Getting started with AAT
 26 Finding an AAT training provider
 48 Distance learning and other ways to study AAT
 25 Apprenticeships
 66 AAT membership