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

Compressing multiple functions across an array into one cell 6
Trying to find additional ranges outside of min, max, and average 2
Problem with SET & REF function 0
Max function for row with named cells 3
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Using MAX with a LOOKUP 3
Combining two formulas 0
Max Length in a row 1

Top