Microsoft Excell 2010

[Dan B]

In one cell I want to enter a material description (ex: D2, A2, DC53, etc..). In another cell I want to enter the weight of the material. In yet another cell I want to have that cell recognize the material description entered and calculate the weight by cost per pound. The cost per pound of material is different per material (ex: [email protected]/lb, [email protected]/lb.). I am unable to get it to recognize the different materials.

Thank you,

Danny

[soybean]

Can you post the formula you tried using to calculate the cost (weight X unit cost)?  Also, can you describe the spreadsheet layout in more detail?  For example, column A is material description, column B is weight, column C is unit cost, etc.

[lau]

The format of your spreadsheet normally determines if your formula works. What you are wanting is pretty simple, but its like Soybean said, material in col A, etc

The formula's in 2010 should be the same as in the previous versions of Excel so a simple formula like =weight*unit cost (eg. =B2*C2 )  should work.