Such calculations are helpful in determining the original price of a sale item purchased or the pretax price of a transaction already done. So 25 14 and the inverse of 14 4. Feb 27 2016 1 Im somewhat new to Excel.
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.
To calculate a reverse percentage convert your percentage by a decimal divide your final amount by the decimal then subtract the original amount from the final amount. B1A2 Formula in B3. Here we have done the reverse calculation of percentage. What Im trying to find is the reverse and can.