| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
criteria function using max
If client age is 50, what amount they can contribute?
"Scott" wrote: I'm trying to set up a max function with two specific criteria. In column C I have client Age In column F I have Employee contribution Criteria: If the client is above the age of 50, the max amount they can contribute is 20000 If the client is below the age of 50, the max they can contribute is 15000 also, in column G, I have employer contribution. I need a formula so that employers cannot contribute more than monthly gross income (column D/12) Thank you very much |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| include criteria to 'rank based array function' | Excel Discussion (Misc queries) | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Countif Function, complex criteria | Excel Worksheet Functions | |||
| SumIf Function using multiple criteria | Excel Worksheet Functions | |||
Threaded Mode
