Prev: Advanced Filtering
Next: ODBC Driver Manager: Option type out of range
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