How to Multiple Quantity & Price in Excel


Microsoft Excel represents a solid choice for database software as it comes with a slew of functionality. A popular feature in Excel is its ability to multiply values together automatically to yield a result. Two factors that can be multiplied include quantity and price. This will yield a result of a final price for the full contents of a package. A few simple steps will enable you to carry out this computation.

  • Create a cell for quantity. In this cell, you will need to enter the quantity of a particular good. For example, this will be Cell "A1."

  • Create a cell for price. In this cell, you will need to enter the price per item of a specific good. Be sure to properly align the price and quantity for each field. For example, this will be Cell "B1."

  • Automate the multiplication. In the next cell, place the following text: "=A1*B1." This will now automatically multiply the quantity by the price and yield a result.

Related Searches


Promoted By Zergnet


You May Also Like

  • How to Make a Time Card in Excel

    Excel's time and date functions make it a useful tool for office management purposes. One of the most basic functions is making...

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!