1750 - 1250 1250 This gives the result 04 or 40. Your cell pointer should now be on. You can calculate percentages in Excel using basic multiplication and division.
Excels formatting options includes a handy button that multiplies by 100 and puts the percentage sign in the result.
To calculate the difference as a percentage we subtract this months value from last months and then divide the result by last months value. Calculate a percent distribution you can use a formula that simply divides an amount by the total. Assuming that the total value is in cell A2 and percent in B2 the above formula turns into a simple A2B2 and returns 10450. We may get the answer in decimal.