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.
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...