"Dave F" wrote in message
...
IF([Age]50,20000,IF([Age]<50,15000))
No need for the second IF()
=IF(C150,20000,15000)
or without an IF()
=15000+(C150)*5000
However, my reading of the OP's question is that the OP is actually looking
for a MIN() function along with the IF()
=MIN(F1,IF(C150,20000,15000))
or
=MIN(F1,15000+(C150)*5000)
For the employer's contribution I would suggest:
=MIN(G1,D1/12)
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
with @tiscali.co.uk
"Dave F" wrote in message
...
IF([Age]50,20000,IF([Age]<50,15000))
--
Brevity is the soul of wit.
"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