I need a total $ based on number of units ordered

[Guest]

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.

 

[Guest]

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

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

 

[Sandy Mann]

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Guest]

In cell F2 try:

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

and then copy it down to F3 thru F6.

Will

 

[Guest]

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

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

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

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

 

[Guest]

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