In situations when you want to multiply all values in a column by the same number, proceed in one of the following ways. ![]() Enter the number to multiply by in some cell, say in B1.Multiply a column by a number with a formulaĪs it happens, the fastest way to do multiplication in Excel is by using the multiply symbol (*), and this task is no exception. ![]() In this example, we are going to multiply a column of numbers by percentage. Since in the internal Excel system percentages are stored as decimal numbers, we can insert either 11% or 0.11 in B1.
0 Comments
Leave a Reply. |