| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if statement
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if statement
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if statement
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. "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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if statement
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. "AmyLRuck" wrote: 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. "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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if statement
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
| SUMIF statement with AND statement | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Hybrid Mode
