the greater of 2 numbers

[Karen]

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.

[Cutter]

in C20 type this formula:

=MAX(C5,C17)

[Bob Phillips]

=MAX(C5,C17)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Karen" <[email protected]> wrote in message
news:[email protected]...
> 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.

[Karen]

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
>
>

[Cutter]

You're welcome