I need a total $ based on number of units ordered

P

Pete Elbert

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.
 
T

tim m

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)))
 
R

roadkill

In cell F2 try:

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

and then copy it down to F3 thru F6.

Will
 
C

CLR

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
 
P

Pete Elbert

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
 
C

CLR

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
 
Top