| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if then forumla | Excel Worksheet Functions | |||
| Most Used Name Forumla | Excel Worksheet Functions | |||
| Forumla | Excel Discussion (Misc queries) | |||
| Forumla Help | Excel Discussion (Misc queries) | |||
| Forumla | Excel Worksheet Functions | |||
Hybrid Mode
