ExcelBanter - greater than forumla

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - greater than forumla (https://www.excelbanter.com/excel-worksheet-functions/223398-greater-than-forumla.html)

Karen

greater than forumla

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

Bernard Liengme[_3_]

greater than forumla

=IF(B2A2,A2,B2)
or more simply
=MIN(A2,B2)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Karen" wrote in message
...
If B2 is greater than A2, enter A2. If B2 is less than A2, enter B2.
What's
the formula for this?

Luke M

greater than forumla

=MIN(A2,B2)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

"Karen" wrote:

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

T. Valko

greater than forumla

What do you want if B2 = A2?

Try this:

=MIN(A2:B2)

--
Biff
Microsoft Excel MVP

"Karen" wrote in message
...
If B2 is greater than A2, enter A2. If B2 is less than A2, enter B2.
What's
the formula for this?

All times are GMT +1. The time now is 05:56 PM.