If the client is above the age of 50
If the client is below the age of 50

What if the client *IS* 50?

Biff

"Scott" wrote in message
...
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