Need help with formula mod

[leopardhawk]

This formula works 100% as intended which is fine when users are 69 years of age or younger. I have discovered that I need to modify it for those users who are 70+ years of age.

=IF(personal_info!$E$12=0,"Estimated value of RRSP at 69 years of age","Estimated value of RRSP at end of "& YEAR(personal_info!$E$12)+69)

Keeping the formula as it is, I need help to modify it somewhat so that if the user's age is 70 or higher, the formula will return "Estimated value of RRSP at the end of CURRENTYEAR".

I hope this makes sense, please let me know if you need more information.

Cheers!

 

[Fluff]

How do you now if they are 70+?

 

[leopardhawk]

Sorry, I made an assumption there... my bad.

They will be entering their DOB on 'personal_info'! in cell E12

Cheers!

 

[Fluff]

How about

=IF(personal_info!$E$12=0,"Estimated value of RRSP at 69 years of age",IF(YEAR(TODAY())-YEAR(personal_info!$E$12) >=70,"Estimated value of RRSP at end of current year","Estimated value of RRSP at end of "& YEAR(personal_info!$E$12)+69))

 

[leopardhawk]

My bad again. Okay the formula is now returning "Estimated value of RRSP at the end of current year". I should have said that "CURRENTYEAR" meant whatever year happens to be the current year, like now it is 2019. Sorry about that.

Cheers!

 

[Fluff]

In that case change
"Estimated value of RRSP at end of current year"
to
"Estimated value of RRSP at end of "&year(today())

 

[leopardhawk]

Thank you so much! Working perfectly.

Cheers!

 

[Fluff]

You're welcome & thanks for the feedback