Calculate the percentage of and convert it to number using a formula in an excel report
Simple formula to convert the percentage into a number, to know the percentage of a percentage and of a number.
When I use the formula ?
To calculate taxes, to know the percentage of a sale, etc.
How to use the formula ?
The formula in this topic is with "," so depending of the operating system of your PC, the formula should have ";" instead of ",".
How are the formula ?
To convert the percentage into a number, formula 1 in cell B4:
=A4*100
To calculate the percentage of a percentage (71.57%), formula 2 in cell C4:
=A4*$C$2
NOTE: don´t forget to format the cells into percentage.
To calculate the percentage of a number (90), formula 3 in cell D4:
=A4*$D$2
Now, imagine that you have those numbers and you want to know the percentage, formula 4:
=D4/$D$2
NOTE: as for the formula 2, don´t forget to format the cells into percentage.
Interesting Topics
-
Be successfully certified ITIL 4 Managing Professional
Study, study and study, I couldn’t be successfully certified without studying it, if you are interested...
-
Be successfully certified ITIL 4 Strategic Leader
With my ITIL 4 Managing Professional certification (ITIL MP) in the pocket, it was time to go for the...
-
Hide visual and change background color based on selection
Some small tricks to customize the background colour of a text box...
-
Stacked and clustered column chart or double stacked column chart
In excel, I use a lot the combination of clustered and stacked chart...