Dear Mr.Robert,
Understand, I can use the formula , =IF(VALUE(YEAR(NOW()))=VALUE($A$9),IF(AE99="","",AE99),"") in B9 , Like this can I use this formula in C9, D9 etc ?.

Is it correct formula to write in B10 , C10 , D10 etc : =IF(VALUE(YEAR(NOW()))=VALUE($A$10),IF(AE99="","",AE99),"")

If I like to copy the formula, I have to remove both dollar sign from A, Am I correct?

Regards,
Shahadat





Quote Originally Posted by Trebor76 View Post
[/COLOR]

This part of the formula is simply anchored (locked) to cell A7. If you want to change when you copy the formula simply remove the dollar signs as appropriate.





It will return a blank as we're not in 2017 for another 15 months but you could use this in cell B9:

=IF(VALUE(YEAR(NOW()))=VALUE($A$9),IF(AE99="","",AE99),"")

Robert