=IF($G8=”yearly”,$Y8*(1+$H8),Y8*(1+$I8))

In this formula Y8 is a growth rate that changes every 12 months. How can i update the formula that it will move that cell reference every 12 cells? I have added year markers but not sure how to reference them

​=IF($G8=”yearly”,$Y8*(1+$H8),Y8*(1+$I8)) In this formula Y8 is a growth rate that changes every 12 months. How can i update the formula that it will move that cell reference every 12 cells? I have added year markers but not sure how to reference them  Read More

​