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
|