Posted to microsoft.public.excel.worksheet.functions
|
|
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?
|