Multiply quantity × unit price (* / PRODUCT)
An order sheet lists quantity in A2:A5 and unit price in B2:B5. Fill Line total in C2:C5 with quantity times price for each row. Excel has no dedicated “multiply function” — use * or PRODUCT.
Your solution should use cell references so it updates automatically when Test Case input values change.
Notes
There is no special 掛け算 function. Write =A2*B2, or =PRODUCT(A2,B2) when you prefer a function name. Both return the same product. A hardcoded 30 fails as soon as quantity or price changes.
Function guide
FAQ
Is there a multiply function in Excel?
There is no dedicated “multiply-only” function people search for. Use the * operator (=A2*B2) or PRODUCT (=PRODUCT(A2,B2)).
How do I multiply two cells?
Write =A2*B2. That is the usual line-total pattern for quantity × price.
When should I use PRODUCT?
PRODUCT is useful when multiplying many numbers or ranges in one call, e.g. =PRODUCT(A2:A5). For two cells, * is shorter and just as clear.