Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 28th 06, 09:20 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4
Default Excel Function for max of percentage or dollar amount

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

  #2   Report Post  
Old July 28th 06, 09:24 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,339
Default Excel Function for max of percentage or dollar amount

=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

  #3   Report Post  
Old July 28th 06, 09:28 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 5,941
Default Excel Function for max of percentage or dollar amount

So long as there are only possible solutions a simple if formula will do...

=IF(5000*0.1400, 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

  #4   Report Post  
Old July 28th 06, 09:29 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 618
Default Excel Function for max of percentage or dollar amount

"Keeprogoal" wrote in message
...
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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
New Excel function SUMABOVE brent Excel Worksheet Functions 12 June 7th 06 01:37 PM
IS THERE AN INTERPOLATION FUNCTION IN EXCEL 2003 Cooper Excel Worksheet Functions 2 December 23rd 05 04:51 AM
How do i execute a VBA function by clicking on an excel cell? Matthew Excel Discussion (Misc queries) 1 December 7th 05 01:10 AM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
CHR() function not working in Excel 2003 Richard Jonas Excel Discussion (Misc queries) 4 February 16th 05 08:45 AM


All times are GMT +1. The time now is 10:16 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017