View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
cfiser
 
Posts: n/a
Default I want the greater number of 2 cells to show in a separate cel

thank you very much, i really appreciate it.


"Ron Coderre" wrote:

A3: =MAX(A1,A2)

Does that help?

€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢
Regards,
Ron


"cfiser" wrote:

I'm sure this is a simple question, but I can't seem to find the answer...I
want the greater number of 2 cells to show in a separate cell
Example...
IF A1 IS GREATER THAN A2 THEN I NEED THE GREATER NUMBER TO BE PLACED IN A3
IF A2 IS GREATER THAN A1 THEN I NEED THE GREATER NUMBER TO BE PLACED IN A3

Thank you