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.
When you are managing a team, “how to be a good manager” is the “must”...
As manager, I am doing many reports, even when I was an ITIL consultant, I still needed to do many reports...
ITIL V3 is going to be obsolete...
Managing an IT service when I start a new company is not an easy task, particularly true, if the service...