Excel formula question - Microsoft Community
Office / Excel / Windows 10 / Unknown/other
i need creating formula automatically perform math equation 2 cells , place total in third cell in row. i want excel every row automatically without having place formula manually each time.
row 200, column d + column j = x multiplied .029 = x + .30=x total placed in column h
50.00+7.60=57.60 x .029=1.67+.30=1.97
hi,
as far understanding correct, in h200
=(d200+j200)*0.029 + 0.30
and drag down/over range need.
Office / Excel / Windows 10 / Unknown/other
Comments
Post a Comment