greater than forumla

Karen · Mar 6, 2009

If B2 is greater than A2, enter A2. If B2 is less than A2, enter B2. What's
the formula for this?

Bernard Liengme · Mar 6, 2009

=IF(B2>A2,A2,B2)
or more simply
=MIN(A2,B2)
best wishes

Luke M · Mar 6, 2009

=MIN(A2,B2)

T. Valko · Mar 6, 2009

What do you want if B2 = A2?

Try this:

=MIN(A2:B2)