I need a total $ based on number of units ordered
 

A B C D
E F
Item No. Units Ordered 1-9 10-19 20-30+ Total
JABDBOM1106 _________ $37.46 $34.44 $32.11 ______
JABDBOM1109 _________ $37.46 $34.44 $32.11 ______
JABDBOM0111NG _________ $52.65 $48.40 $45.13 ______
JABDBOM0113NG _________ $52.65 $48.40 $45.13 ______
JABDBOM1206 _________ $37.46 $34.44 $32.11 ______

What I am trying to accomplish is when I enter a number inot the "Units
Ordered" column (B2:B6), based on the columns C,D,&E, I want the total to
relfect the total amount of $ based on the Units ordered and taking the
information from the correct column. I hope this explains better what I am
trying to accomplish. Thanks to anyone that can help.

I need a total $ based on number of units ordered
 

Try this formula in your total column and copy it down.

=IF(B219,B2*E2,IF(B29,B2*D2, IF(B2<10,B2*C2)))

"Pete Elbert" wrote:

A B C D
E F
Item No. Units Ordered 1-9 10-19 20-30+ Total
JABDBOM1106 _________ $37.46 $34.44 $32.11 ______
JABDBOM1109 _________ $37.46 $34.44 $32.11 ______
JABDBOM0111NG _________ $52.65 $48.40 $45.13 ______
JABDBOM0113NG _________ $52.65 $48.40 $45.13 ______
JABDBOM1206 _________ $37.46 $34.44 $32.11 ______

What I am trying to accomplish is when I enter a number inot the "Units
Ordered" column (B2:B6), based on the columns C,D,&E, I want the total to
relfect the total amount of $ based on the Units ordered and taking the
information from the correct column. I hope this explains better what I am
trying to accomplish. Thanks to anyone that can help.

I need a total $ based on number of units ordered
 

Try:

=B2*OFFSET(B2,0,MIN(CEILING(B2,10)/10,3))

in F2 and copy down.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Pete Elbert" wrote in message
...
A B C D
E F
Item No. Units Ordered 1-9 10-19 20-30+
Total
JABDBOM1106 _________ $37.46 $34.44 $32.11 ______
JABDBOM1109 _________ $37.46 $34.44 $32.11 ______
JABDBOM0111NG _________ $52.65 $48.40 $45.13 ______
JABDBOM0113NG _________ $52.65 $48.40 $45.13 ______
JABDBOM1206 _________ $37.46 $34.44 $32.11 ______

What I am trying to accomplish is when I enter a number inot the "Units
Ordered" column (B2:B6), based on the columns C,D,&E, I want the total to
relfect the total amount of $ based on the Units ordered and taking the
information from the correct column. I hope this explains better what I am
trying to accomplish. Thanks to anyone that can help.

I need a total $ based on number of units ordered
 

In cell F2 try:

=IF(B2<=9,C2,IF(B2<=19,D2,E2))*B2

and then copy it down to F3 thru F6.

Will

"Pete Elbert" wrote:

A B C D
E F
Item No. Units Ordered 1-9 10-19 20-30+ Total
JABDBOM1106 _________ $37.46 $34.44 $32.11 ______
JABDBOM1109 _________ $37.46 $34.44 $32.11 ______
JABDBOM0111NG _________ $52.65 $48.40 $45.13 ______
JABDBOM0113NG _________ $52.65 $48.40 $45.13 ______
JABDBOM1206 _________ $37.46 $34.44 $32.11 ______

What I am trying to accomplish is when I enter a number inot the "Units
Ordered" column (B2:B6), based on the columns C,D,&E, I want the total to
relfect the total amount of $ based on the Units ordered and taking the
information from the correct column. I hope this explains better what I am
trying to accomplish. Thanks to anyone that can help.

I need a total $ based on number of units ordered
 

In F2, put this formula and copy down........

=IF(B219,B2*E2,IF(B29,B2*D2,B2*C2))

Vaya con Dios,
Chuck, CABGx3




"Pete Elbert" wrote:

A B C D
E F
Item No. Units Ordered 1-9 10-19 20-30+ Total
JABDBOM1106 _________ $37.46 $34.44 $32.11 ______
JABDBOM1109 _________ $37.46 $34.44 $32.11 ______
JABDBOM0111NG _________ $52.65 $48.40 $45.13 ______
JABDBOM0113NG _________ $52.65 $48.40 $45.13 ______
JABDBOM1206 _________ $37.46 $34.44 $32.11 ______

What I am trying to accomplish is when I enter a number inot the "Units
Ordered" column (B2:B6), based on the columns C,D,&E, I want the total to
relfect the total amount of $ based on the Units ordered and taking the
information from the correct column. I hope this explains better what I am
trying to accomplish. Thanks to anyone that can help.

I need a total $ based on number of units ordered
 

Thanks for all of the suggestions, they are all very helpful and they do
exactly what I need for them to do. I just need to choose one. Again,
thanks for the quick and effiecient responses. I do appreciate all of you.
Take care and maybe one day I can return the favor. Pete Elbert

"Pete Elbert" wrote:

A B C D
E F
Item No. Units Ordered 1-9 10-19 20-30+ Total
JABDBOM1106 _________ $37.46 $34.44 $32.11 ______
JABDBOM1109 _________ $37.46 $34.44 $32.11 ______
JABDBOM0111NG _________ $52.65 $48.40 $45.13 ______
JABDBOM0113NG _________ $52.65 $48.40 $45.13 ______
JABDBOM1206 _________ $37.46 $34.44 $32.11 ______

What I am trying to accomplish is when I enter a number inot the "Units
Ordered" column (B2:B6), based on the columns C,D,&E, I want the total to
relfect the total amount of $ based on the Units ordered and taking the
information from the correct column. I hope this explains better what I am
trying to accomplish. Thanks to anyone that can help.

I need a total $ based on number of units ordered
 

We're counting on it Pete. Thats how this thing works so good, someone helps
you, then you help someone else........it'a a wonderful thing. The OP can
get several approaches and choose the one best fitting their application and
skill level.

Vaya con Dios,
Chuck, CABGx3



"Pete Elbert" wrote:

Thanks for all of the suggestions, they are all very helpful and they do
exactly what I need for them to do. I just need to choose one. Again,
thanks for the quick and effiecient responses. I do appreciate all of you.
Take care and maybe one day I can return the favor. Pete Elbert

"Pete Elbert" wrote:

A B C D
E F
Item No. Units Ordered 1-9 10-19 20-30+ Total
JABDBOM1106 _________ $37.46 $34.44 $32.11 ______
JABDBOM1109 _________ $37.46 $34.44 $32.11 ______
JABDBOM0111NG _________ $52.65 $48.40 $45.13 ______
JABDBOM0113NG _________ $52.65 $48.40 $45.13 ______
JABDBOM1206 _________ $37.46 $34.44 $32.11 ______

What I am trying to accomplish is when I enter a number inot the "Units
Ordered" column (B2:B6), based on the columns C,D,&E, I want the total to
relfect the total amount of $ based on the Units ordered and taking the
information from the correct column. I hope this explains better what I am
trying to accomplish. Thanks to anyone that can help.