Hello - I need to compare two cells and return one or the other depending on which is greater....
so formula would be something like 'if A2<B2, then A2. If A2>B2, then B2'
thank you!!
Hello - I need to compare two cells and return one or the other depending on which is greater....
so formula would be something like 'if A2<B2, then A2. If A2>B2, then B2'
thank you!!
Try this in C2 then just copy down.
=IF(A2<B2,A2,B2)
FYI - It is actually which is not greater according to your expected result in your sheet.
Shorter a little bit:
=MIN(A2,B2)
Quang PT
Thank you all so much this worked!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks