Please tell me an excel formula to add in following manner:
If a1 = 1640, a2 = a1+65, a3=a2+65, a4=a3+65, a5=a4+65, a6=a5+65 until it reaches 2095
then a7=a6+80.........until it reaches 3135
then next cell=the previous result+100...................until it reaches 3635
If a1 = 1640, a2 = a1+65, a3=a2+65, a4=a3+65, a5=a4+65, a6=a5+65 until it reaches 2095
then a7=a6+80.........until it reaches 3135
then next cell=the previous result+100...................until it reaches 3635