Create a formula in the selected cell that multiplies the value in cell b2 of the current worksheet
1 answer:
To multiply two cells in Excel, use a multiplication formula like in the above example, but supply cell references instead of numbers. For example, to multiply the value in cell A2 by the value in B2, type this expression is A2*B2.
What do you under stand by Excel?
Microsoft's spreadsheet program Excel is a part of the Office family of products used for business purposes. Users can format, arrange, and compute data in a spreadsheet using Microsoft Excel.
To create formula in the selected cell follow these steps:
The PRODUCT function would be the quickest technique to multiply several cells or ranges.
Where number1, number2, etc. are numbers, cells or ranges that you want to multiply.
to multiply values in cells A2, B2 and C2, use this formula is PRODUCT(A2:C2)
To multiply the numbers in cells A2 through C2, and then multiply the result by 3, is PRODUCT(A2:C2,3)
Learn more about Excel click on this:
#SPJ4
You might be interested in