Excel pattern recognition

Copper Contributor

Hi,  I am trying to calculate some percentages and the steps for achieving the same is as follows



  1. choose the  cell or sum of the cells below
  2. Subtract this with next corresponding cell value
  3. Divide it by the aforementioned sum
  4. 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.

1 Reply



With percentage formatting 2023-03-02 09_29_17-Classeur1 - Excel.png