Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 18
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 320
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,722
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
COUNTIF Function issue Gweduc Excel Worksheet Functions 5 July 30th 09 10:43 PM
Weeknum function issue WS Excel Worksheet Functions 7 February 4th 09 12:10 PM
YEAR function issue Barb Reinhardt Excel Worksheet Functions 1 April 24th 07 06:12 PM
Date function/Text issue MijC Excel Worksheet Functions 10 December 6th 05 09:34 PM
This is Weird - Dead Simple Issue with Sum Function Neilibeg Excel Worksheet Functions 2 July 16th 05 08:15 PM


All times are GMT +1. The time now is 02:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"