breakpoint calculation
=LOOKUP(A1,{0,45,100,300,500,10000},{9.5,8.5,7.5,4 .5,3.5,1.5})*A1
"Oliver" wrote: 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(weight45,weight<10 0), 8.5*weight, etc etc) but it will be a long formula... i think it must have an easy way to do this... |
All times are GMT +1. The time now is 05:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com