the greater of 2 numbers

K

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

Bob Phillips

=MAX(C5,C17)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
K

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting two cell dates and highlight if over due by a certain amount of days 0
Goal Seek with variable Set Cell 1
Really simple macro problem - I bet! 2
Formula Problem 3
Excel does not accept text format! 0
=min =max 1
Adding cells until they are greater than a lookup cell and returning a value 1
Autonumber field in Excel that behaves the same as Access 0

Top