In the example shown the formula in D6 is. New_valueold_value-1 Select a blank cell where I need to enter the formula ie. For example if you want to calculate 20 of 500 multiply 20 by 500.
Change changeinitial value 100.
Now to calculate percentage of total write this Percentage formula in cell C4 and drag it down. The values inside the parentheses calculate first so ther value of C2 is subtracted from 1 to give us 75. For example if you want to calculate 25 of 50 multiply 25 by 50. For example if you want to calculate 20 of 500 multiply 20 by 500.