Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MAX Function Issue
I implemented the function MAX(C136:D136) to get the maximum value of these
two cells. Each cell has a formula that resolves to a number. What I get is the max value concatenated three times. Any ideas?? W. Wolfe |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MAX Function Issue
press ctrl/shift/1 on that cell. Seems like yuo have it formatted as Fill.
ctrl/shift/1 formats it as General. HTH Bob Umlas ExceL MVP "William Wolfe" wrote in message ... I implemented the function MAX(C136:D136) to get the maximum value of these two cells. Each cell has a formula that resolves to a number. What I get is the max value concatenated three times. Any ideas?? W. Wolfe |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MAX Function Issue
What are the exact formulas you are using? Both the 2 creating numbers, and
formula with the MAX function. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "William Wolfe" wrote: I implemented the function MAX(C136:D136) to get the maximum value of these two cells. Each cell has a formula that resolves to a number. What I get is the max value concatenated three times. Any ideas?? W. Wolfe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF Function issue | Excel Worksheet Functions | |||
Weeknum function issue | Excel Worksheet Functions | |||
YEAR function issue | Excel Worksheet Functions | |||
Date function/Text issue | Excel Worksheet Functions | |||
This is Weird - Dead Simple Issue with Sum Function | Excel Worksheet Functions |