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