Doing basic math in Excel is easy, but multiplying by 10 percent can be a little more complicated. Fortunately, there are a few different ways you can use Excel to multiply a number by 10 percent. This tutorial will explain how to use Excel to multiply by 10 percent, both in the form of a percentage and as a decimal. With these techniques, you'll be multiplying by 10 percent in no time.
How to Multiply by 10 Percent as a Percentage
The first step in multiplying by 10 percent is to convert the 10 percent into a decimal. To do this, simply move the decimal place two spaces to the left. For example, 10 percent as a decimal is 0.10. Once you have the decimal, you can enter it into a cell in Excel. For example, if you want to multiply the number 120 by 10 percent, you could enter 120 into one cell, and 0.10 into a cell next to it.
Once you have the numbers entered, you can use the formula =A1*B1, where A1 is the cell with the number you want to multiply and B1 is the cell with the decimal. This will give you the result of 12, which is the same as multiplying 120 by 10 percent. You can also use the formula =A1*0.1, which will also give you the same result.
How to Multiply by 10 Percent as a Decimal
The other way to multiply by 10 percent in Excel is by entering the number as a decimal instead of a percentage. To do this, you'll need to convert 10 percent into a decimal. To convert 10 percent into a decimal, you'll need to move the decimal point two places to the left. This will give you 0.1, which is the same as 10 percent as a decimal.
Once you have the decimal, you can enter it into a cell in Excel. For example, if you want to multiply the number 120 by 10 percent, you could enter 120 into one cell, and 0.1 into a cell next to it. Once you have the numbers entered, you can use the formula =A1*B1, where A1 is the cell with the number you want to multiply and B1 is the cell with the decimal. This will give you the result of 12, which is the same as multiplying 120 by 10 percent.
Using the Excel Function to Multiply by 10 Percent
Excel also has a built-in function that can help you multiply by 10 percent. The function is called the PERCENT function. To use the function, you'll need to enter the number you want to multiply by 10 percent in one cell, and then enter the formula =PERCENT(A1,10) in another cell, where A1 is the cell with the number you want to multiply.
This will give you the same result as the other methods: multiplying 120 by 10 percent will give you 12. The PERCENT function is a great way to quickly and easily multiply by 10 percent in Excel.
Using the Percent Formatting in Excel
Another way to multiply by 10 percent in Excel is to use the Percent formatting option in Excel. To use this option, select the cell that contains the number you want to multiply by 10 percent. Then, select the Percent formatting option in the Format Cells window. Once you have selected the Percent formatting option, enter 10 in the cell and Excel will automatically multiply the number in the cell by 10 percent.
For example, if you enter 120 in the cell and select the Percent formatting option, Excel will automatically multiply 120 by 10 percent and display the result of 12 in the cell. This is a great way to quickly and easily multiply by 10 percent in Excel.
Conclusion
Multiplying by 10 percent in Excel is easy once you know how. In this tutorial, we explained how to use Excel to multiply by 10 percent, both in the form of a percentage and as a decimal. We also explained how to use the Excel function and the Percent formatting option to quickly and easily multiply by 10 percent. With these techniques, you'll be multiplying by 10 percent in no time.