create a formula based on age in date format and amount contributed

[truth192]

Basically,

I want to create a formula to see if a person overcontributed or not based on their birth date (m,dd,yyyy), if their 50 and older then the max amount They can contribute is a certain XX firgure and if their below 50, then its another figure. I want it to return "Overcontributed" if they went over the dollar amount and "No" if they didnt. I have a unique identifier for each individual. I also have all the year to date contribution and gross pay.

[bsandt22]

Hey there,

Please see the workbook I attached!

Let me know if you need more explanation here.

You dont necessarily need to utilize a table here if theres set values for contribution caps. Additionally, this formula assumes that you're using their age as the current day. If you are using their age at the end of a fixed range that would be an easy edit.

You'd also be able to edit this for additional age traunches