| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If, greater than
I need, if a1 is greater than b1 than print a1. If b1 is greater than a1
than print b1. I haven't been able to find anything of any help in the help screens. -- Jerre |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If, greater than
=if(a1b1, a1, b1)
-- HTH... Jim Thomlinson "Jerre" wrote: I need, if a1 is greater than b1 than print a1. If b1 is greater than a1 than print b1. I haven't been able to find anything of any help in the help screens. -- Jerre |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If, greater than
This formula should do what you want...
=MAX(A1,B1) Rick "Jerre" wrote in message ... I need, if a1 is greater than b1 than print a1. If b1 is greater than a1 than print b1. I haven't been able to find anything of any help in the help screens. -- Jerre |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If, greater than
Try this:
=MAX(A1,B1) -- Biff Microsoft Excel MVP "Jerre" wrote in message ... I need, if a1 is greater than b1 than print a1. If b1 is greater than a1 than print b1. I haven't been able to find anything of any help in the help screens. -- Jerre |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If, greater than
What do you mean by "print"? HTH Otto
"Jerre" wrote in message ... I need, if a1 is greater than b1 than print a1. If b1 is greater than a1 than print b1. I haven't been able to find anything of any help in the help screens. -- Jerre |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if greater than? | Excel Worksheet Functions | |||
| If sum greater than 12 use 12 | Excel Discussion (Misc queries) | |||
| greater than but less than | Excel Discussion (Misc queries) | |||
| if value is greater than # * by 20% if less * by 40 | New Users to Excel | |||
| Greater Than but Less than | Excel Worksheet Functions | |||
Hybrid Mode
