searchsolution
New Member
- Joined
- Jan 18, 2014
- Messages
- 5
I am having trouble to get a solution for creating a formula to calculate with an array constant and then tell me if the calculated amounts equal a designated amount. This is what I have so far:
=IF(SUM(YEAR(A2)+{5;10;15;20;25;30;35;40;45;50})=YEAR(TODAY());"jubilee";"")
Can anyone help quickly?
=IF(SUM(YEAR(A2)+{5;10;15;20;25;30;35;40;45;50})=YEAR(TODAY());"jubilee";"")
Can anyone help quickly?