PDA

View Full Version : [SOLVED] Increase number every nth year



av8tordude
03-20-2014, 11:57 AM
Can I receive some assistance. In column G, I would like the values to increase every nth year in (E18) by the value in (E17). See attachments

Thank you for your help.

xld
03-20-2014, 12:21 PM
In G36, enter

=G35+IF(MOD(ROW()-ROW($G$35),$E$18)<>0,0,$E$17)

and copy down

av8tordude
03-20-2014, 12:51 PM
Thank you XLD! Works great. I really appreciate all you help!