Return value based on criteria

[Rportz]

I need cell B7 to enter the daily payment rate based on the value that is entered in cell B1. For instance, if the no. of miles traveled (cell B1) is 17 then the daily travel rate will return $10.00 (cell B7).

Any help is so appreciated!!

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD="align: right"]No miles traveled:
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Miles
[/TD]
[TD]Daily Payment Rate
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]15 miles per day or less
[/TD]
[TD]$5.00
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]16-30 miles per day
[/TD]
[TD]$10.00
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]31-45 miles per day
[/TD]
[TD]$15.00
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]46-60 miles per day
[/TD]
[TD]$20.00
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD="align: right"]Daily Travel Rate:
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[AhoyNC]

Here's one way:

Excel Workbook
	A	B
1	No miles traveled:	17
2	Miles	Daily Payment Rate
3	15 miles per day or less	$5.00
4	16-30 miles per day	$10.00
5	31-45 miles per day	$15.00
6	46-60 miles per day	$20.00
7	Daily Travel Rate:	$10.00
Sheet