| 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. |
| 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 | |||
Threaded Mode
