Need help regarding Excel formula

Question

If multiple values are given in Excel sheets, then how to calculate the any percentage on fixed value for example we have 18000 thousand rupees but we need to Calculate any percentage on only 15000 ,then how to calculate it?

Answer 1

Rajesh,

Alternative 1

If your rupee amounts are in column A, then you could write a formula in column B that reads:

=A1/150000

Then, you would copy that formula down column B for all cells for which you would like to know what percentage of 150,000 the number in column A is.

This will give you the percentage in decimal format. If you would like to convert the resultant number from decimal to percentage format, select the cell and hit the Control-Shift-5 keystroke to convert it to the percentage format.

Alternative 2

If you are interested in seeing what percent numbers are to a base number that will change, you could type the base number, say 150000 in cell C1. Then your formula in column B would be:

=A1/C$1

Then you can copy this formula down the column, as the formula will always divide the number in Column A by whatever number you have entered into C1.

I hope this answers your question.

Tom