Juli
Column A for item name.
Column B for item price.
Column C for item quantity.
Column D for item price*quantity.
e.g.
A1 is widget
B1 is $5.00 cost per each
C1 is 34 widgets.
D1 contains formula =B1*C1 returns $170.00
Copy the D1 formula down column D as far as you have data in A, B and C columns.
Gord Dibben MS Excel MVP
On Wed, 1 Mar 2006 16:37:27 -0800, "Juli Cliff" <Juli
wrote:
I want to create an inventory spreadsheet - I'm a new user.
I want a column for the item, a column for the price of the item, a column
for the quantity and a column for the total - ( price x quantity)
Can you give me a very easy way to do this in laymans language?