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 FilteringNext: ODBC Driver Manager: Option type out of range