| Home |
| Search |
| Today's Posts |
|
#1
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
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
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
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating a Formula Subject to a Maximum and Minimum Value | Excel Worksheet Functions | |||
| Calculating value less minimum numbers in the sequence | Excel Worksheet Functions | |||
| using min function without calculating 0 as minimum | New Users to Excel | |||
| How to lookup the minimum, 2nd minimum and 3rd minimum......... | Excel Worksheet Functions | |||
| calculating the minimum value ignoring o | Excel Worksheet Functions | |||
Linear Mode
