the greater of 2 numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
=MAX(C5,C17)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
thank you. from there I was able to figure out my other question by coming
up with =min(2.5%*c17,30.00). thanks for such a simple fix.
 
Back
Top