Google Spreadsheet a column mirrors a different columns values when it shouldnt be -

ive been working on spreadsheet examine something. converting recursive formula linear one. initial value or first state 60. second state 240. done taking previous state, doubling it, , adding 120. leads 3rd , 4th states of 600 , 1320. base formula clear enough (60+120)*2^(n-1)-120 accurately expresses it.

my second part comes needing add in ability decrease costs while still staying true state. last formula works when cost reduction 0. after considerable effort (i kept having minor rounding errors) arrived @ (round(60-60*0.015*b$2)+(120-round(120*rounddown(b$2/3)*0.03,0)))*2^($a2-1)-(120-round(120*rounddown(b$2/3)*0.03,0)).

to test formulas created table following values, a2=1 a5=4, , b2=0 h2=6. using google spreadsheets examine information. when populate table found values correct formula, except on g. on g values identical f. try , correct have deleted information cells, deleted columns, , tried again in new spreadsheet. in cases g=f when should not. cant figure out why i'm getting duplicate column.

the information on row 3 values should using.

the expected values g4=55, g5=226, g6=568, g7=1252.

in case wanted know, managed solve issue. needed round in 1 more place. following formula has worked current testing.

sum((round(60-round(60*0.015*a$2))+(120-round(120*rounddown(a$2/3)*0.03,0)))*2^($a25-1)-(120-round(120*rounddown(a$2/3)*0.03,0)))