ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   MAX Function Issue (https://www.excelbanter.com/excel-worksheet-functions/239780-max-function-issue.html)

William Wolfe

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



Bob Umlas[_3_]

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




Luke M

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





All times are GMT +1. The time now is 04:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com