the greater of 2 numbers
 

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.

the greater of 2 numbers
 

in C20 type this formula:

=MAX(C5,C17)


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=512776

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.

the greater of 2 numbers
 

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.

"Cutter" wrote:


in C20 type this formula:

=MAX(C5,C17)


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=512776

the greater of 2 numbers
 

You're welcome


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=512776