O
Oliver
The following is a presentation of rate table:
<45kg +45KG +100KG +300KG +500KG +10000KG
$9.5 $8.5 $7.5 $4.5 $3.5 $1.5
It reads if weight is smaller than 45kg then we charge $9.5 per kg; if
weight is between 45 and 100kg then we charge $8.5 and so on; is there
an easy way to write a formula to calculate the total charge based on
the weight?
I could use if(weight<45,9.5*weight,if(and(weight>45,weight<100),
8.5*weight, etc etc) but it will be a long formula...
i think it must have an easy way to do this...
<45kg +45KG +100KG +300KG +500KG +10000KG
$9.5 $8.5 $7.5 $4.5 $3.5 $1.5
It reads if weight is smaller than 45kg then we charge $9.5 per kg; if
weight is between 45 and 100kg then we charge $8.5 and so on; is there
an easy way to write a formula to calculate the total charge based on
the weight?
I could use if(weight<45,9.5*weight,if(and(weight>45,weight<100),
8.5*weight, etc etc) but it will be a long formula...
i think it must have an easy way to do this...