Hi is it possible to just enter the formula once in a cell and call it on the next cell if needed? What I'm doing now is copy the formula in the succeeding cells to make it work.
for example:
I have a formula in M6 which is =(I6+J6+K6)*0.115, O6 which is =(J6+M6+I6+K6)*0.13 and P6 which is =J6+M6+O6+K6+I6. So if I enter an amount in I6, J6 and K6 the formulas will run. Is there a way that it will be automatic in the next row 7 without dragging the formula all the way down?
Thanks in advance!