Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function help
hello group. i have a simple question. tried excell help, but no luck
yet. my employee makes a commision, or a gaurantee, whichever is higher. i need excell to result the only the greater value of 2 cells. does anybody know this function? thanks in advance. dave. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function help
Try something like this:
For values in A1 and B1 This formula returns the larger value: C1: =MAX(A1,B1) Is that something you can work with? *********** Regards, Ron XL2002, WinXP "George Whodunnit" wrote: hello group. i have a simple question. tried excell help, but no luck yet. my employee makes a commision, or a gaurantee, whichever is higher. i need excell to result the only the greater value of 2 cells. does anybody know this function? thanks in advance. dave. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |