From: hotrodflatglass on 18 Mar 2010 04:14 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  Thanks Mike
From: trip_to_tokyo on 18 Mar 2010 04:51 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
From: hotrodflatglass on 18 Mar 2010 05:40 Column A Has part numbers, Column B Has prices Column C customer chose the amount of each items he needs, D15 Will have the total $ amount of order.  Thanks Mike "trip_to_tokyo" wrote: > 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 >
From: dlw on 18 Mar 2010 09:48 to get total, in D15, put =sum(D1:D14) "hotrodflatglass" wrote: > Column A Has part numbers, Column B Has prices Column C customer chose the > amount of each items he needs, D15 Will have the total $ amount of order. >  > Thanks > Mike > > > "trip_to_tokyo" wrote: > > > 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 > >

Pages: 1 Prev: Advanced Filtering Next: ODBC Driver Manager: Option type out of range 