View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Bob Phillips
 
Posts: n/a
Default the greater of 2 numbers

=MAX(C5,C17)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Karen" wrote in message
...
I am working on an excel spreadsheet. I am in cell C20. I want to tell

IT
to look at C5 and C17, determine the greater of the 2 numbers and enter

the
greater one in that cell(C20). Can anyone help me with an easy formula?

I
certainly would appreciate it.