our cost to customers cost
 

in one cell would like to display our cost, in another the formula for cust.
cost. the formula only works on the high end and the low end, everything in
the mid. won't work,can anyone please help me out ?

=IF(A150,A1*1.4,A1*1.55,IF(A1<25,A1*1.8,IF(A1<6,A 1*2.45,IF(A1<5,A1*2.85,
IF(A1<3,A1*3.25,IF(A1<1,A1*5.8,A1*4))))))

Would I need an = infront of each IF statement ?

At the end of your formula, what is the condition that gets multiplied by 4?

Besides that, with the number of variables, it would be best to create a
data list, perhaps in an out-of-the-way location on your sheet, and refer to
it to return the customer cost.

Say in J1 to J7 you enter:
0, 1, 3, 5, 6, 25, 50

And in K1 to K7 you enter:
5.8, 3.25, 2.85, 2.45, 1.8, 1.55, 1.4

Then try this formula:

=A1*LOOKUP(A1,J1:J7,K1:K7)

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"thisguy" wrote in message
...
in one cell would like to display our cost, in another the formula for
cust.
cost. the formula only works on the high end and the low end, everything
in
the mid. won't work,can anyone please help me out ?

=IF(A150,A1*1.4,A1*1.55,IF(A1<25,A1*1.8,IF(A1<6,A 1*2.45,IF(A1<5,A1*2.85,
IF(A1<3,A1*3.25,IF(A1<1,A1*5.8,A1*4))))))

Would I need an = infront of each IF statement ?

Is there a wy of doing it
=IF(25<A1<50,A1*1.55,IF(6<A1<25,A1*1.8,IF(4<A1<6,A 1*2.65,IF(2<A1<4,A1*3.62,IF(A150,A1*1.4,

Could something like this work ? or would a look up table still be a better
bet ?


"RagDyer" wrote:

At the end of your formula, what is the condition that gets multiplied by 4?

Besides that, with the number of variables, it would be best to create a
data list, perhaps in an out-of-the-way location on your sheet, and refer to
it to return the customer cost.

Say in J1 to J7 you enter:
0, 1, 3, 5, 6, 25, 50

And in K1 to K7 you enter:
5.8, 3.25, 2.85, 2.45, 1.8, 1.55, 1.4

Then try this formula:

=A1*LOOKUP(A1,J1:J7,K1:K7)

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"thisguy" wrote in message
...
in one cell would like to display our cost, in another the formula for
cust.
cost. the formula only works on the high end and the low end, everything
in
the mid. won't work,can anyone please help me out ?

=IF(A150,A1*1.4,A1*1.55,IF(A1<25,A1*1.8,IF(A1<6,A 1*2.45,IF(A1<5,A1*2.85,
IF(A1<3,A1*3.25,IF(A1<1,A1*5.8,A1*4))))))

Would I need an = infront of each IF statement ?

A table is better.

BUT, *if you insist*, you can include it within the formula itself:

=A1*LOOKUP(A1,{0,1,3,5,6,25,50;5.8,3.25,2.85,2.45, 1.8,1.55,1.4})
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"thisguy" wrote in message
...
Is there a wy of doing it
=IF(25<A1<50,A1*1.55,IF(6<A1<25,A1*1.8,IF(4<A1<6,A 1*2.65,IF(2<A1<4,A1*3.62,I
F(A150,A1*1.4,

Could something like this work ? or would a look up table still be a better
bet ?


"RagDyer" wrote:

At the end of your formula, what is the condition that gets multiplied by
4?

Besides that, with the number of variables, it would be best to create a
data list, perhaps in an out-of-the-way location on your sheet, and refer
to
it to return the customer cost.

Say in J1 to J7 you enter:
0, 1, 3, 5, 6, 25, 50

And in K1 to K7 you enter:
5.8, 3.25, 2.85, 2.45, 1.8, 1.55, 1.4

Then try this formula:

=A1*LOOKUP(A1,J1:J7,K1:K7)

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"thisguy" wrote in message
...
in one cell would like to display our cost, in another the formula for
cust.
cost. the formula only works on the high end and the low end, everything
in
the mid. won't work,can anyone please help me out ?


=IF(A150,A1*1.4,A1*1.55,IF(A1<25,A1*1.8,IF(A1<6,A 1*2.45,IF(A1<5,A1*2.85,
IF(A1<3,A1*3.25,IF(A1<1,A1*5.8,A1*4))))))

Would I need an = infront of each IF statement ?