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
 
Ad

Advertisements

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
 
Ad

Advertisements

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

Top