varible calculation
I am trying to create a calculation for haulage/trucking charges
1-300 kilos £ 30 300-400 kilos £ 35 400-500 kilos £ 40 What formula could I use to accomplish this?? -- kinsey |
varible calculation
assuming that you mean:
1-299 300-399 400- then try: =LOOKUP(A1,{0,300,400},{30,35,40}) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "kinsey" wrote in message ... I am trying to create a calculation for haulage/trucking charges 1-300 kilos £ 30 300-400 kilos £ 35 400-500 kilos £ 40 What formula could I use to accomplish this?? -- kinsey |
varible calculation
if the weight is in cel A1 you could try
=IF(A1300,IF(AND(A1300,A1<400),35,40),30) you will need to change it slightly as you have 2 values for 300 & 400 kilo's. You might also want some validation to prevent the cell having a value over 500 kilo's -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "kinsey" wrote: I am trying to create a calculation for haulage/trucking charges 1-300 kilos £ 30 300-400 kilos £ 35 400-500 kilos £ 40 What formula could I use to accomplish this?? -- kinsey |
varible calculation
This formula presumes that you have a cell named weight and that weight is
not 0, and that any weight over 400 kilos is £ 40. You can make it more elaborate. For a few more weights, you could do a table lookup. =IF(weight<=300,30,IF(weight<=400,35,40)) "kinsey" wrote in message ... I am trying to create a calculation for haulage/trucking charges 1-300 kilos £ 30 300-400 kilos £ 35 400-500 kilos £ 40 What formula could I use to accomplish this?? -- kinsey |
varible calculation
First I think you have a couple of typos. You can't have two rates for 300 or
400 Maybe you mean 1-300 301-400 401-500 or do you mean? 1-299 300-399 400-500 Will there ever be fractions like 299.96 kg? Will there ever be more than 500 kg? If so, would the max be £40 =LOOKUP(A1,{1,301,401,501},{30,35,40,40}) Try the above............adjust ranges as needed. Gord Dibben MS Excel MVP On Sat, 29 Sep 2007 13:26:03 -0700, kinsey wrote: I am trying to create a calculation for haulage/trucking charges 1-300 kilos £ 30 300-400 kilos £ 35 400-500 kilos £ 40 What formula could I use to accomplish this?? |
varible calculation
Sorry, didn't pay enough attention. The formula will not work. Your criteria
need clarification. 1-300 kilos is £ 30, 300 - 400 kilos is £ 35. You can't have that. 300 kilos is both £ 30 and £ 35 and 400 kilos is both £ 35 and £ 40. "kinsey" wrote in message ... I am trying to create a calculation for haulage/trucking charges 1-300 kilos £ 30 300-400 kilos £ 35 400-500 kilos £ 40 What formula could I use to accomplish this?? -- kinsey |
varible calculation
many thanks
-- kinsey "Sandy Mann" wrote: assuming that you mean: 1-299 300-399 400- then try: =LOOKUP(A1,{0,300,400},{30,35,40}) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "kinsey" wrote in message ... I am trying to create a calculation for haulage/trucking charges 1-300 kilos £ 30 300-400 kilos £ 35 400-500 kilos £ 40 What formula could I use to accomplish this?? -- kinsey |
varible calculation
works a treat! many thanks
-- kinsey "Gord Dibben" wrote: First I think you have a couple of typos. You can't have two rates for 300 or 400 Maybe you mean 1-300 301-400 401-500 or do you mean? 1-299 300-399 400-500 Will there ever be fractions like 299.96 kg? Will there ever be more than 500 kg? If so, would the max be £40 =LOOKUP(A1,{1,301,401,501},{30,35,40,40}) Try the above............adjust ranges as needed. Gord Dibben MS Excel MVP On Sat, 29 Sep 2007 13:26:03 -0700, kinsey wrote: I am trying to create a calculation for haulage/trucking charges 1-300 kilos £ 30 300-400 kilos £ 35 400-500 kilos £ 40 What formula could I use to accomplish this?? |
All times are GMT +1. The time now is 07:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com