|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 8th, 2010, 08:57 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating a minimum fee
I'm looking for a formula that will calculate the following information:
If 15% of the sum of a range of cells is less than $40.00 then the fee is $40.00. If 15% of the sum of a range of cells is $40.00 or higher, then the fee is 15%. I hope that made sense. In other words, the fee is 15% or $40, whichever is higher. 
|
|
#2
January 8th, 2010, 09:10 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculating a minimum fee
Hi
Look at this: =MAX(A1*0.15,40) Regards, Per "Jackie" skrev i meddelelsen ... I'm looking for a formula that will calculate the following information: If 15% of the sum of a range of cells is less than $40.00 then the fee is $40.00. If 15% of the sum of a range of cells is $40.00 or higher, then the fee is 15%. I hope that made sense. In other words, the fee is 15% or $40, whichever is higher.
|
|
#3
January 8th, 2010, 09:13 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculating a minimum fee
=MAX(40,15%*SUM(A1:A9))
Adjust the range (A1:A9) to your needs -- Kind regards, Niek Otten Microsoft MVP - Excel "Jackie" wrote in message ... I'm looking for a formula that will calculate the following information: If 15% of the sum of a range of cells is less than $40.00 then the fee is $40.00. If 15% of the sum of a range of cells is $40.00 or higher, then the fee is 15%. I hope that made sense. In other words, the fee is 15% or $40, whichever is higher.
|
|
#4
January 8th, 2010, 09:29 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculating a minimum fee
YOU ARE FABULOUS! THANK YOU SO MUCH.
"Niek Otten" wrote: =MAX(40,15%*SUM(A1:A9)) Adjust the range (A1:A9) to your needs -- Kind regards, Niek Otten Microsoft MVP - Excel "Jackie" wrote in message ... I'm looking for a formula that will calculate the following information: If 15% of the sum of a range of cells is less than $40.00 then the fee is $40.00. If 15% of the sum of a range of cells is $40.00 or higher, then the fee is 15%. I hope that made sense. In other words, the fee is 15% or $40, whichever is higher.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
