I figured out how to do this with an If statement. Thank you for your
assistance.

"Sheeloo" wrote:

You can setup your ranges in another sheet (Col A & B) like the following;
0 Value for 0-9
10 Value for 10-99
100 Value for 100-999
1000 Value for 999



If your price is in A1 then in B1 enter
=VLOOKUP(A1,Sheet2!A:B,2,TRUE)

"AmyLRuck" wrote:

I am trying to insert a shipping and handling rate based on the cost of the
purchase. How can I write an if statement based on different price ranges?