| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula w/two columns to add the greater number
Hello,
If I have two columns with different number and I want to choose the bigger number of both columns, how can I do it. -- Thank you. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula w/two columns to add the greater number
Try this
=Large(A1:B100,1) On Sep 19, 12:58*am, Saul wrote: Hello, If I have two columns with different number and I want to choose the bigger number of both columns, how can I do it. -- Thank you. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula w/two columns to add the greater number
Try this:
=MAX(A1:B10) -- Biff Microsoft Excel MVP "Saul" wrote in message ... Hello, If I have two columns with different number and I want to choose the bigger number of both columns, how can I do it. -- Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DISPLAY A FIXED NUMBER IF GREATER THAN FORMULA RESULTS | Excel Discussion (Misc queries) | |||
| countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) | |||
| Formula for number of entries in colum that are greater than 2 hr | New Users to Excel | |||
| count a number that is less than a number and greater than a numbe | Excel Worksheet Functions | |||
| IF ranges for multiple columns greater then less then | Excel Worksheet Functions | |||
Linear Mode
