Mike, not quite sure what you want but here goes anyway.

Assuming that you have:-

price of 65 in cell B2

quantity of 3 in cell C2

Put:-

=(B2*C2)

- in cell D2 and this will give you an answer of 195 (in cell D 2).

If this is what you want please hit Yes.

Thanks.





"hotrodflatglass" wrote:

A1 through A9 Has part numbers

B1 through B9 has price

C1 through c9 has quanitys required to make a set

D1 gives total Price of set

A1 part#1

B1 $65.00

c1 requires 3

for a set D1 total price