multiple criteria formula

[Guest]

I am trying to create muliple formulas for one column.

Column C - I have client Age

Column G - This is going to be any value, however if the client is younger
than 50 years of age, the max value is $15,000. If the client is above the
age of 50, the max value is $20,000.

Also, in column H, I need the max to be 4% of Column D divided by twelve
(monthly income)

Thank you

Thank you very much

 

[Guest]

to get the 4%, in H1 enter =D1*.04/12. As far as Col G is concerned, not
quite sure what you want. Is it only the two values, or are there more. If
only the 2, then use
=IF(C1="","",IF(<50,15000,20000))

If there are more options, I would suggest that you draw up a table of
possible values and criteria for each. I suppose criteria would have to be
age. You can then name this table, eg Criteria. Your formula would then be
=IF(C1="","",VLOOKUP(C1,Criteria,2,0))

 

[Guest]

to get the 4%, in H1 enter =D1*.04/12. As far as Col G is concerned, not
quite sure what you want. Is it only the two values, or are there more. If
only the 2, then use
=IF(C1="","",IF(<50,15000,20000))

If there are more options, I would suggest that you draw up a table of
possible values and criteria for each. I suppose criteria would have to be
age. You can then name this table, eg Criteria. Your formula would then be
=IF(C1="","",VLOOKUP(C1,Criteria,2,0))