Here we have done the reverse calculation of percentage. Step 3 Divide the final number by the decimal to get back to the original number. If your input data includes the percentage then it is resulted from this calculation.
For example if you have a column containing numbers and want to calculate 10 of one of those numbers enter 10 in another cell then use a formula using the asterisk.
Step 3 Divide the final number by the decimal to get back to the original number. Step 2 Divide the percentage by 100 to convert it to a decimal. Enter an old number in cell A1 and a new number in cell B1. I have several accounts that someone enter the wrong amount in and I need to find the correct amount.