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]

Unit Weight	Weight Ranges	Price
2.2kg	0-1kg	$10
	1-2kg	$20
	2-3kg	$30
	3-4kg	$40

<thead style="box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-family: inherit; vertical-align: baseline;">
</thead><tbody style="box-sizing: border-box; margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-family: inherit; vertical-align: baseline;">
</tbody>

[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.