View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
 
Posts: 1,104
Default 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?