Formula to apply a charge per kilo in a range of weight

[Xamores]

Hello, I have the value in cell C4, I need to calculate the total freight depending on the range of weight:

So the value I need is that the weight indicated in C4 be Multiplied by the value of its tariff in this case 265..53 X 5.68 5 more than 100 less than 300. so if it is less than 45 = C4 x c34, more than 45 and less than 100 C4 Multiplied by C35, etc etc, and if this final result is less that C33 then C33. I hope it is clear.

 

[SanjayGMusafir]

Best would be to create a lookup array where excel can lookup and return a specified rate as per the actual weight. This shall give you flexibility to change rate or weight slabs as per your need.

We had many similar posts on this forum. I shall find one and quote to give you a better prespective.

 

[SanjayGMusafir]

The post may not be exact as you need but look at #2 by @awoohaw That solution is exact to your need. Still trying to find some solution where range are mentioned

LOOKUP result vector error

I have an issue with a LOOKUP function where the result vector is showing an incorrect value, but only for a specific lookup vector. There are 66 rows in the table but only one row has the incorrect value. The value are related to time. Cheers

www.mrexcel.com

 

[SanjayGMusafir]

again #2 by @awoohaw is answer to your problem

Lookup/Vlookup to find exact date

I am using the formula below to try and extract data from another workbook. It works fine until there is a date with no associated values. In the formula, "D1" is the destination sheet's date, and column B is the date column in the source sheet. Column J is the data I want to extract. For...

www.mrexcel.com

 

[SanjayGMusafir]

Using above instances -

Book1
	A	B	C	D	E	F
1					Wt	Tarrif
2	265.53	5.68			0	7.72
3					45	6.4
4					100	5.68
5					300	4.8
6					500	4.36
7					1000	4.36
8					10000	4.36
Sheet1

Cell Formulas
Range	Formula
B2	B2	=LOOKUP(A2,E2:E8,F2:F8)