Hi, I am trying to calculate some percentages and the steps for achieving the same is as follows
- choose the cell or sum of the cells below
- Subtract this with next corresponding cell value
- Divide it by the aforementioned sum
- Multiply the result with 100
Pattern is not being recognized. Instead of incrementing the cells for the next step, it's copying the formulas and calculating the values.
Thank you in advance.