MAX Function Issue

W

William Wolfe

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
 
B

Bob Umlas

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
 
L

Luke M

What are the exact formulas you are using? Both the 2 creating numbers, and
formula with the MAX function.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Max function for row with named cells 3
Trying to find additional ranges outside of min, max, and average 2
Another zero question 3
Using MAX with a LOOKUP 3
conditions and the max function 1
Excel Trying to code an Array Function in VBA Excel to works as a MaxIF 3
Cell value using Max 3
Help with Vlookup and MAX functions 4

Top