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 ?
|