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

IN cell A3 put this

=MAX(A1:A2)

Vaya con Dios,
Chuck, CABGx3


"cfiser" wrote in message
...
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