Answer:
You can use the percentage sign in a formula or use the value as a decimal. If you have a value in B3 and want to find ten percent of it, you could use either of the following formulas in another cell:
=B3*10%
=B3*0.1
IF you want to reduce a value by a percent, you need to find that percentage and take it away from the total, or multiply the value by the remaining percentage. If you want to take 10% off something, then you can find the 10% and take it away like this:
=B3-(B3*10%)
Or you could just get 90% of the original value:
=B3*90%
If you want to find what percentage one number is of another, then you divide one into another. So if you wanted to find what percentage 53 is of 92 then you would use the following formula:
=53/92
If you wanted to find what percentage 92 is of 53 then you would use the following formula:
=92/53
You would then format the result as a percentage. Instead of actually typing numbers into the formulas, you would put the two values into cells and then use the formula to reference the cells. So if the 53 is in A2 and 92 is in A3 then the two above formulas would be:
=A2/A1
=A1/A2
Note that if you merely want to display the percentage symbol after your number, you can use the format options to format the cell. Choose the Custom option and enter the formula as a hash mark followed by a double-quoted percent sign: #"%"