leopardhawk
Well-known Member
- Joined
- May 31, 2007
- Messages
- 611
- Office Version
- 2016
- Platform
- Windows
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.
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!
Code:
=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!