# Excel Function for max of percentage or dollar amount

=?Utf-8?B?S2VlcHJvZ29hbA==?=
Guest
Posts: n/a

 28th Jul 2006
I am working on an excel project in which I have a rent price say \$5000. With
this rent I am trying to find a formula in which I can find the maximum one
needs to pay on this rent. The maximum is either a percentage of that rent or
a dollar amount. For example say the percentage is 10% of this rent or the
fixed amount is \$400. I am trying to get the formula to decide which is
greater, and then have this information placed in another cell as the maximum
payment due on the rent of the two possibilities (either 10% of \$5000 or
\$400).

Thank you,
Philip

=?Utf-8?B?VG9wcGVycw==?=
Guest
Posts: n/a

 28th Jul 2006
=Max(5000*0.1,400)

=MAX(A1*B1,C1)

A1=5000
B1=10% (cell formatted as %)
C1=400

HTH

"Keeprogoal" wrote:

> I am working on an excel project in which I have a rent price say \$5000. With
> this rent I am trying to find a formula in which I can find the maximum one
> needs to pay on this rent. The maximum is either a percentage of that rent or
> a dollar amount. For example say the percentage is 10% of this rent or the
> fixed amount is \$400. I am trying to get the formula to decide which is
> greater, and then have this information placed in another cell as the maximum
> payment due on the rent of the two possibilities (either 10% of \$5000 or
> \$400).
>
> Thank you,
> Philip

=?Utf-8?B?SmltIFRob21saW5zb24=?=
Guest
Posts: n/a

 28th Jul 2006
So long as there are only possible solutions a simple if formula will do...

=IF(5000*0.1>400, 5000*0.1, 400)

You can substitute the hard coded numbers for cell references...
--
HTH...

Jim Thomlinson

"Keeprogoal" wrote:

> I am working on an excel project in which I have a rent price say \$5000. With
> this rent I am trying to find a formula in which I can find the maximum one
> needs to pay on this rent. The maximum is either a percentage of that rent or
> a dollar amount. For example say the percentage is 10% of this rent or the
> fixed amount is \$400. I am trying to get the formula to decide which is
> greater, and then have this information placed in another cell as the maximum
> payment due on the rent of the two possibilities (either 10% of \$5000 or
> \$400).
>
> Thank you,
> Philip

David Biddulph
Guest
Posts: n/a

 28th Jul 2006
"Keeprogoal" <(E-Mail Removed)> wrote in message
news:A53F44D7-FF3A-4944-A16B-(E-Mail Removed)...
>I am working on an excel project in which I have a rent price say \$5000.
>With
> this rent I am trying to find a formula in which I can find the maximum
> one
> needs to pay on this rent. The maximum is either a percentage of that rent
> or
> a dollar amount. For example say the percentage is 10% of this rent or
> the
> fixed amount is \$400. I am trying to get the formula to decide which is
> greater, and then have this information placed in another cell as the
> maximum
> payment due on the rent of the two possibilities (either 10% of \$5000 or
> \$400).

=MAX(10%*5000,400)

You can, of course, replace any or all of the numbers by cell references.
--
David Biddulph

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Mel Microsoft Excel Worksheet Functions 9 20th Nov 2008 10:50 PM =?Utf-8?B?S2VsbHk=?= Microsoft Excel Misc 2 4th Nov 2004 07:33 PM Michael Chong Microsoft Excel New Users 1 26th Oct 2004 10:23 AM Michael Chong Microsoft Excel Misc 1 26th Oct 2004 10:19 AM Peo Sjoblom Microsoft Excel Worksheet Functions 0 21st Nov 2003 06:21 PM

Features