if statement

  • Thread starter Thread starter AmyLRuck
  • Start date Start date
A

AmyLRuck

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?
 
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)
 
This will not work because I have an exact value and I need to look for it in
a range...a vlookup cannot figure that out.
 
VLOOKUP with TRUE can lookup the value in a range
In the example I have given any value between 10 and 99 will return 'value
between 10-99'

If you have exact result for each value then use VLOOKUP with FALSE.

Glad you solved the prob lem on your own.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a row immediately following a "true" statement 1
Not sure what the best function should be. 6
vlookup if statement help needed 2
Help with really big IF statement 0
return value based on another value 4
IF Statements 2
How do I invoice a cost to a custom built MS Access Accounting Database? 0
excel formula for markup and profit margin 3

Back
Top