Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
nesting conditional formulas
I am trying to create a complicated formula which will look at a cell and
multiply it by a number which is dependant upon what the number in the original cell is. For example, if B2 is 99 or less, then multiply by 6. If it is between 1 and 3, then multiply by 5, if it is between 3.01 and 5, then multiply by 4, etc. All in all, there would be about 10 of those situations, but if I can get some help starting it off, I can finish it up. Thanks in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
nesting conditional formulas
You can't use a formula in a cell that uses that cell's original value. It
cannot have both a value and a formula. If you can use other cells, take a look at VLOOKUP in help, it will do what you want. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Nancy" wrote in message ... I am trying to create a complicated formula which will look at a cell and multiply it by a number which is dependant upon what the number in the original cell is. For example, if B2 is 99 or less, then multiply by 6. If it is between 1 and 3, then multiply by 5, if it is between 3.01 and 5, then multiply by 4, etc. All in all, there would be about 10 of those situations, but if I can get some help starting it off, I can finish it up. Thanks in advance. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
nesting conditional formulas
My bad, I worded that question wrong.
I looked up the VLOOKUP and I still don't understand. Here is some more clarity. In cell C1, I'm trying to create a formula that will take the value of cell B1 and multiply it by a number, dependant upon the beginning value of cell B1. What I am trying to do it show what the markup value for our products should be. If they COST (listed in cell B1) us less than a dollar, then the markup should be 500% (multiply by 6) to be displayed in cell C1. if the cost (B1) is 1.00-3.00, then multiply by 5, if the cost is 3.01-5.00, multiply by 4, etc... I did this formula once before, but it was a terribly long time ago and I've since lost it. Thanks for your reply. "Bob Phillips" wrote: You can't use a formula in a cell that uses that cell's original value. It cannot have both a value and a formula. If you can use other cells, take a look at VLOOKUP in help, it will do what you want. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Nancy" wrote in message ... I am trying to create a complicated formula which will look at a cell and multiply it by a number which is dependant upon what the number in the original cell is. For example, if B2 is 99 or less, then multiply by 6. If it is between 1 and 3, then multiply by 5, if it is between 3.01 and 5, then multiply by 4, etc. All in all, there would be about 10 of those situations, but if I can get some help starting it off, I can finish it up. Thanks in advance. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
nesting conditional formulas
I KNOW that the following formula is incorrect, but can someone at least tell
me if if I'm on the right track? =OR(IF(B1<1, B1*6, 0)),IF(OR(B1.99, B1<3.01), B1*5,0),IF(OR(B13.00, B1<5.01),B1*4,0)) "Nancy" wrote: I am trying to create a complicated formula which will look at a cell and multiply it by a number which is dependant upon what the number in the original cell is. For example, if B2 is 99 or less, then multiply by 6. If it is between 1 and 3, then multiply by 5, if it is between 3.01 and 5, then multiply by 4, etc. All in all, there would be about 10 of those situations, but if I can get some help starting it off, I can finish it up. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format Not Working | Excel Discussion (Misc queries) | |||
conditional formulas | Excel Worksheet Functions | |||
conditional formulas | Excel Worksheet Functions | |||
Help Using Formulas in Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional formulas in excel | Excel Worksheet Functions |