Formula help. Find the correct price based on weight range.

[gcnick1977]

[FONT=&quot]I'm stuck on a formula with the below set up.[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]I need to find the correct price based on the unit weight using weight ranges. [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot] [/FONT]
[TABLE="class: jiveBorder, width: 915"]
<thead style="box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-family: inherit; vertical-align: baseline;">[TR]
[TH="class: header, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6690BC]#6690BC[/URL] , align: center"]Unit Weight[/TH]
[TH="class: header, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6690BC]#6690BC[/URL] , align: center"]Weight Ranges[/TH]
[TH="class: header, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=6690BC]#6690BC[/URL] , align: center"]Price[/TH]
[/TR]
</thead><tbody style="box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-family: inherit; vertical-align: baseline;">[TR]
[TD="align: center"]2.2kg[/TD]
[TD="align: center"]0-1kg
[/TD]
[TD="align: center"]$10[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]1-2kg[/TD]
[TD="align: center"]$20[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]2-3kg[/TD]
[TD="align: center"]$30[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]3-4kg[/TD]
[TD="align: center"]$40[/TD]
[/TR]
</tbody>[/TABLE]
[FONT=&quot]
[/FONT]
[FONT=&quot]Example Answers.[/FONT]
[FONT=&quot]Unit Weight <1kg = $10[/FONT]
[FONT=&quot]Unit Weight >1kg & <2kg = $20[/FONT]
[FONT=&quot]Unit Weight >2kg & <3kg = $30[/FONT]
[FONT=&quot]Unit Weight >3kg & <4kg = $40[/FONT]
[FONT=&quot]
Thanks.[/FONT]

 

[AhoyNC]

Based on your current set up try:
Also it's unclear if 2kg should be $20 or $30 (same with 1 and 3 kg, which range should they fall in?).

Excel Workbook
	A	B	C
1	Unit Weight	Weight Ranges	Price
2	2.2kg	0-1kg	$10
3	$30	1-2kg	$20
4		2-3kg	$30
5		3-4kg	$40
Sheet

 

[gcnick1977]

Thanks for the post. I ended up using the below.

 

[AhoyNC]

Your changes to the setup are a lot better than what you were using at first. Also, will be a lot easier to change rates in the future.