| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF then statements-Tiered PRicing
Please help!
I am going to have to create an Excel spread using tiered pricing. I imagine it will be: IF QUANTITY PRICE <100 10.00 100 5.00 Please help-I have no idea how to use an "IF" statement to make this work and this is what my boss wants. Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF then statements-Tiered PRicing
=IF(X<100,10,IF(X100,5))
You don't specify what happens if X = 100. Dave -- Brevity is the soul of wit. "Jackiec21" wrote: Please help! I am going to have to create an Excel spread using tiered pricing. I imagine it will be: IF QUANTITY PRICE <100 10.00 100 5.00 Please help-I have no idea how to use an "IF" statement to make this work and this is what my boss wants. Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF then statements-Tiered PRicing
Thank you for your quick response. If X=100, then price is $8.00, so how do
I need to enter that one?? "Dave F" wrote: =IF(X<100,10,IF(X100,5)) You don't specify what happens if X = 100. Dave -- Brevity is the soul of wit. "Jackiec21" wrote: Please help! I am going to have to create an Excel spread using tiered pricing. I imagine it will be: IF QUANTITY PRICE <100 10.00 100 5.00 Please help-I have no idea how to use an "IF" statement to make this work and this is what my boss wants. Thanks! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF then statements-Tiered PRicing
=IF(X<100,10,IF(X=100,8,IF(X100,5)))
Dave -- Brevity is the soul of wit. "Jackiec21" wrote: Thank you for your quick response. If X=100, then price is $8.00, so how do I need to enter that one?? "Dave F" wrote: =IF(X<100,10,IF(X100,5)) You don't specify what happens if X = 100. Dave -- Brevity is the soul of wit. "Jackiec21" wrote: Please help! I am going to have to create an Excel spread using tiered pricing. I imagine it will be: IF QUANTITY PRICE <100 10.00 100 5.00 Please help-I have no idea how to use an "IF" statement to make this work and this is what my boss wants. Thanks! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF then statements-Tiered PRicing
=IF(X<100,10,IF(X=100,8,5))
"Jackiec21" wrote: Thank you for your quick response. If X=100, then price is $8.00, so how do I need to enter that one?? "Dave F" wrote: =IF(X<100,10,IF(X100,5)) You don't specify what happens if X = 100. Dave -- Brevity is the soul of wit. "Jackiec21" wrote: Please help! I am going to have to create an Excel spread using tiered pricing. I imagine it will be: IF QUANTITY PRICE <100 10.00 100 5.00 Please help-I have no idea how to use an "IF" statement to make this work and this is what my boss wants. Thanks! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF then statements-Tiered PRicing
What I am trying to do is say-if a customer orders 95 widgits, then the price
is $10.00. If the customer orders 105 widgits (or some other number) than the price is $5.00. I am still not clear on how to get a price to calculate, as I received a "False" answer. Thanks for any additional help! "Dave F" wrote: =IF(X<100,10,IF(X100,5)) You don't specify what happens if X = 100. Dave -- Brevity is the soul of wit. "Jackiec21" wrote: Please help! I am going to have to create an Excel spread using tiered pricing. I imagine it will be: IF QUANTITY PRICE <100 10.00 100 5.00 Please help-I have no idea how to use an "IF" statement to make this work and this is what my boss wants. Thanks! |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF then statements-Tiered PRicing
Assume A1 has the number of widgets ordered.
Then: =IF(A1=95,10,IF(A1=105,5)) If you want to avoid the FALSE value, you have to either specify what your ELSE clause is, which you haven't done, or, otherwise, suppress errors, as in: =IF(A1=95,10,IF(A1=105,5,"")) In plain English this says: "IF A1 is 95, THEN 10, ELSE IF A1 is 105, THEN 5, ELSE return an empty string." Dave -- Brevity is the soul of wit. "Jackiec21" wrote: What I am trying to do is say-if a customer orders 95 widgits, then the price is $10.00. If the customer orders 105 widgits (or some other number) than the price is $5.00. I am still not clear on how to get a price to calculate, as I received a "False" answer. Thanks for any additional help! "Dave F" wrote: =IF(X<100,10,IF(X100,5)) You don't specify what happens if X = 100. Dave -- Brevity is the soul of wit. "Jackiec21" wrote: Please help! I am going to have to create an Excel spread using tiered pricing. I imagine it will be: IF QUANTITY PRICE <100 10.00 100 5.00 Please help-I have no idea how to use an "IF" statement to make this work and this is what my boss wants. Thanks! |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF then statements-Tiered PRicing
Assume A1 has the number of widgets ordered, then to calculate price in (say)
B1: =IF(A1<100,10,IF(A1=100,8,5)) HTH "Dave F" wrote: Assume A1 has the number of widgets ordered. Then: =IF(A1=95,10,IF(A1=105,5)) If you want to avoid the FALSE value, you have to either specify what your ELSE clause is, which you haven't done, or, otherwise, suppress errors, as in: =IF(A1=95,10,IF(A1=105,5,"")) In plain English this says: "IF A1 is 95, THEN 10, ELSE IF A1 is 105, THEN 5, ELSE return an empty string." Dave -- Brevity is the soul of wit. "Jackiec21" wrote: What I am trying to do is say-if a customer orders 95 widgits, then the price is $10.00. If the customer orders 105 widgits (or some other number) than the price is $5.00. I am still not clear on how to get a price to calculate, as I received a "False" answer. Thanks for any additional help! "Dave F" wrote: =IF(X<100,10,IF(X100,5)) You don't specify what happens if X = 100. Dave -- Brevity is the soul of wit. "Jackiec21" wrote: Please help! I am going to have to create an Excel spread using tiered pricing. I imagine it will be: IF QUANTITY PRICE <100 10.00 100 5.00 Please help-I have no idea how to use an "IF" statement to make this work and this is what my boss wants. Thanks! |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF then statements-Tiered PRicing
Yeah, that defines the ELSE clause.
-- Brevity is the soul of wit. "Toppers" wrote: Assume A1 has the number of widgets ordered, then to calculate price in (say) B1: =IF(A1<100,10,IF(A1=100,8,5)) HTH "Dave F" wrote: Assume A1 has the number of widgets ordered. Then: =IF(A1=95,10,IF(A1=105,5)) If you want to avoid the FALSE value, you have to either specify what your ELSE clause is, which you haven't done, or, otherwise, suppress errors, as in: =IF(A1=95,10,IF(A1=105,5,"")) In plain English this says: "IF A1 is 95, THEN 10, ELSE IF A1 is 105, THEN 5, ELSE return an empty string." Dave -- Brevity is the soul of wit. "Jackiec21" wrote: What I am trying to do is say-if a customer orders 95 widgits, then the price is $10.00. If the customer orders 105 widgits (or some other number) than the price is $5.00. I am still not clear on how to get a price to calculate, as I received a "False" answer. Thanks for any additional help! "Dave F" wrote: =IF(X<100,10,IF(X100,5)) You don't specify what happens if X = 100. Dave -- Brevity is the soul of wit. "Jackiec21" wrote: Please help! I am going to have to create an Excel spread using tiered pricing. I imagine it will be: IF QUANTITY PRICE <100 10.00 100 5.00 Please help-I have no idea how to use an "IF" statement to make this work and this is what my boss wants. Thanks! |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF then statements-Tiered PRicing
Assume A1 has the number of widgets ordered ......
I like what you said ...... *ordered* is the keyword. If the user enters a negative number to A1 to indicate the number of widgets *returned*, say -200, then the pricing will be off. Yes, the poster did say "order." I just want to highlight the fact that there shouldn't be any negative numbers in A1. Epinn "Toppers" wrote in message ... Assume A1 has the number of widgets ordered, then to calculate price in (say) B1: =IF(A1<100,10,IF(A1=100,8,5)) HTH "Dave F" wrote: Assume A1 has the number of widgets ordered. Then: =IF(A1=95,10,IF(A1=105,5)) If you want to avoid the FALSE value, you have to either specify what your ELSE clause is, which you haven't done, or, otherwise, suppress errors, as in: =IF(A1=95,10,IF(A1=105,5,"")) In plain English this says: "IF A1 is 95, THEN 10, ELSE IF A1 is 105, THEN 5, ELSE return an empty string." Dave -- Brevity is the soul of wit. "Jackiec21" wrote: What I am trying to do is say-if a customer orders 95 widgits, then the price is $10.00. If the customer orders 105 widgits (or some other number) than the price is $5.00. I am still not clear on how to get a price to calculate, as I received a "False" answer. Thanks for any additional help! "Dave F" wrote: =IF(X<100,10,IF(X100,5)) You don't specify what happens if X = 100. Dave -- Brevity is the soul of wit. "Jackiec21" wrote: Please help! I am going to have to create an Excel spread using tiered pricing. I imagine it will be: IF QUANTITY PRICE <100 10.00 100 5.00 Please help-I have no idea how to use an "IF" statement to make this work and this is what my boss wants. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2 IF Statements not mutually exclusive | Excel Discussion (Misc queries) | |||
| UDFunctions and nested If-the-else statements | Excel Worksheet Functions | |||
| Linking two IF statements together | Excel Discussion (Misc queries) | |||
| Volume and pricing calculations | Excel Worksheet Functions | |||
| Nested IF statements | Excel Worksheet Functions | |||
Hybrid Mode
