| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
excel inventory spreadsheet
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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
excel inventory spreadsheet
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Excel 97 read Excel 2003 simple spreadsheet? | Excel Discussion (Misc queries) | |||
| Delay to startup excel spreadsheet | Excel Worksheet Functions | |||
| copy and paste excel spreadsheet into autocad | Excel Discussion (Misc queries) | |||
| Excel 2K3: Opening spreadsheet, also opens book1.xls? | Setting up and Configuration of Excel | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
Linear Mode
