How do I create a formula in excell that multiplies a number by a pertectage?

Answer 1

= [number] * [number]%

Answer 2

I would recommend choosing a specific cell within your spreadsheet and input your percentage into that cell as a decimal (IE .05=5%). Then, from the tool bar, format this cell into a percentage, this will show you what percentage you are using. You can now us a simply formula; =+A1*A2.
Doing it this way you can then change your percentage in one field to see what the changing outcome is. It is easier than updating each cell that is being multiplied by the same percentage.

Answer 3

It depends what you want to do.

If it is for bussiness, your best bet is to make the "percent" a variable outside of the cell you are using it.

What I am trying to say is make it so that you are referanceing to the a cell rather then typing it into your formula.

The reason you should do this is so that later you can easly change the percent without rewriting your whole spreadsheet.

so for example...
in cell A1: 10%
in cell A2: =500*A1


but if you are looking for an easy answer,.. simply type the following.

in cell A1: =100*50%

(usualy it is in best form to write your percentages in decimal tho, so the above would look like this...)

in cell A1: =100*0.5


Ah and lastly remember if you want to "add" a persentage to your current valure, be sure that you include 100%... for example..

in cell A1: =100*0.5 (100 x 50% would be 50)
in cell A2: =100*1.5 (100 plus (100x50%) would be 150) <- - good for figuring out interest.



hope this helps

=)

Answer 4

Xerocs is correct. To multiply the number in cell A1 by a percentage (let's say 5%) you enter the formula:
=(A1*5%)
or
=(A1*.05)

If you want to show the number after a 5% _increase_ you could do this:
=(A1*105%)
or
=(A1*1.05)

Answer 5

As a percent is just a fancy way to write a decimal, you simple multiple the number by the decimal for the percent. 10% is .10, 20% is .25 25% is .25, 50% is .50, 100% is 1.00, 38.9% is .389, etc.

Answer 6

Convert the percentage into a decimal and multuply it by the number.

Answer 7

=sum(8*.875)

Break the percentage down into decimals first then multiply as the preceding says.