| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Data Validation - IF statements
I am having problems with 7 Nested IF functions in data validation.
What is the best way around formulas using more than 7 IF functions? How do you write an IF function in VBA where there are more than seven statements? Thanks |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Data Validation - IF statements
Can you provide a more detailed explanation of what you're trying to do?
There are many ways to get around a bunch of nested if statements. -- Biff Microsoft Excel MVP "CC" wrote in message ... I am having problems with 7 Nested IF functions in data validation. What is the best way around formulas using more than 7 IF functions? How do you write an IF function in VBA where there are more than seven statements? Thanks |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Data Validation - IF statements
I am trying to do the following:
I have established various combinations of cells to create a frame type and called given it a name. e.g. =IF(R17="Brown",OR(AG17="Grey",AG17="Red")), "Brown Frame") I have placed these formulas at the bottom of my spreadsheet, where it is not visible. In another cell I want that framename (which is the name of the list created) to be displayed with a dropdown list of variations of type that go with this framing. e.g. IF(M217="Brown Frame",brownframe,IF(P217="Green Frame",greenframe))etc (I have placed this under Validation-List. I come unstruck when I have too many of these IF statements. Thanks for your help. CC "T. Valko" wrote in message ... Can you provide a more detailed explanation of what you're trying to do? There are many ways to get around a bunch of nested if statements. -- Biff Microsoft Excel MVP "CC" wrote in message ... I am having problems with 7 Nested IF functions in data validation. What is the best way around formulas using more than 7 IF functions? How do you write an IF function in VBA where there are more than seven statements? Thanks |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Data Validation - IF statements
Ok...
IF(M217="Brown Frame",brownframe,IF(P217="Green Frame",greenframe))etc It looks like row 217 contains your formula results. But, how do you control which list to use? Will there only be 1 cell on row 217 that actually contains a frame name? This formula returns an error. =IF(R17="Brown",OR(AG17="Grey",AG17="Red")), "Brown Frame") Maybe you meant: =IF(R17="Brown",IF(OR(AG17="Grey",AG17="Red"),"Bro wn Frame")) This will return either Brown Frame or FALSE. So, does that mean row 217 contains 1 frame name and a bunch of FALSEs ? -- Biff Microsoft Excel MVP "CC" wrote in message ... I am trying to do the following: I have established various combinations of cells to create a frame type and called given it a name. e.g. =IF(R17="Brown",OR(AG17="Grey",AG17="Red")), "Brown Frame") I have placed these formulas at the bottom of my spreadsheet, where it is not visible. In another cell I want that framename (which is the name of the list created) to be displayed with a dropdown list of variations of type that go with this framing. e.g. IF(M217="Brown Frame",brownframe,IF(P217="Green Frame",greenframe))etc (I have placed this under Validation-List. I come unstruck when I have too many of these IF statements. Thanks for your help. CC "T. Valko" wrote in message ... Can you provide a more detailed explanation of what you're trying to do? There are many ways to get around a bunch of nested if statements. -- Biff Microsoft Excel MVP "CC" wrote in message ... I am having problems with 7 Nested IF functions in data validation. What is the best way around formulas using more than 7 IF functions? How do you write an IF function in VBA where there are more than seven statements? Thanks |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Data Validation - IF statements
M217 to Y217 each contain a different frame name
My formula on each of these cells reads: IF(AND(R17"Material Type",OR(AG17="Hinge type",AG17="Hinge direction"))"Frame Name",0) each of these formulas determine what list I want the validation to choose and create a drop down list. Only one cell on R17 contains the list from the validation. Your help is so appreciated. I am learning new things all the time and at moment doing some e-learning on Excel but have yet to learn the more advanced skills. CC "T. Valko" wrote in message ... Ok... IF(M217="Brown Frame",brownframe,IF(P217="Green Frame",greenframe))etc It looks like row 217 contains your formula results. But, how do you control which list to use? Will there only be 1 cell on row 217 that actually contains a frame name? This formula returns an error. =IF(R17="Brown",OR(AG17="Grey",AG17="Red")), "Brown Frame") Maybe you meant: =IF(R17="Brown",IF(OR(AG17="Grey",AG17="Red"),"Bro wn Frame")) This will return either Brown Frame or FALSE. So, does that mean row 217 contains 1 frame name and a bunch of FALSEs ? -- Biff Microsoft Excel MVP "CC" wrote in message ... I am trying to do the following: I have established various combinations of cells to create a frame type and called given it a name. e.g. =IF(R17="Brown",OR(AG17="Grey",AG17="Red")), "Brown Frame") I have placed these formulas at the bottom of my spreadsheet, where it is not visible. In another cell I want that framename (which is the name of the list created) to be displayed with a dropdown list of variations of type that go with this framing. e.g. IF(M217="Brown Frame",brownframe,IF(P217="Green Frame",greenframe))etc (I have placed this under Validation-List. I come unstruck when I have too many of these IF statements. Thanks for your help. CC "T. Valko" wrote in message ... Can you provide a more detailed explanation of what you're trying to do? There are many ways to get around a bunch of nested if statements. -- Biff Microsoft Excel MVP "CC" wrote in message ... I am having problems with 7 Nested IF functions in data validation. What is the best way around formulas using more than 7 IF functions? How do you write an IF function in VBA where there are more than seven statements? Thanks |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Data Validation - IF statements
Ok...
M217 to Y217 each contain a different frame name If each cell contains a name then what determines which of those names is the source for your list? -- Biff Microsoft Excel MVP "CC" wrote in message ... M217 to Y217 each contain a different frame name My formula on each of these cells reads: IF(AND(R17"Material Type",OR(AG17="Hinge type",AG17="Hinge direction"))"Frame Name",0) each of these formulas determine what list I want the validation to choose and create a drop down list. Only one cell on R17 contains the list from the validation. Your help is so appreciated. I am learning new things all the time and at moment doing some e-learning on Excel but have yet to learn the more advanced skills. CC "T. Valko" wrote in message ... Ok... IF(M217="Brown Frame",brownframe,IF(P217="Green Frame",greenframe))etc It looks like row 217 contains your formula results. But, how do you control which list to use? Will there only be 1 cell on row 217 that actually contains a frame name? This formula returns an error. =IF(R17="Brown",OR(AG17="Grey",AG17="Red")), "Brown Frame") Maybe you meant: =IF(R17="Brown",IF(OR(AG17="Grey",AG17="Red"),"Bro wn Frame")) This will return either Brown Frame or FALSE. So, does that mean row 217 contains 1 frame name and a bunch of FALSEs ? -- Biff Microsoft Excel MVP "CC" wrote in message ... I am trying to do the following: I have established various combinations of cells to create a frame type and called given it a name. e.g. =IF(R17="Brown",OR(AG17="Grey",AG17="Red")), "Brown Frame") I have placed these formulas at the bottom of my spreadsheet, where it is not visible. In another cell I want that framename (which is the name of the list created) to be displayed with a dropdown list of variations of type that go with this framing. e.g. IF(M217="Brown Frame",brownframe,IF(P217="Green Frame",greenframe))etc (I have placed this under Validation-List. I come unstruck when I have too many of these IF statements. Thanks for your help. CC "T. Valko" wrote in message ... Can you provide a more detailed explanation of what you're trying to do? There are many ways to get around a bunch of nested if statements. -- Biff Microsoft Excel MVP "CC" wrote in message ... I am having problems with 7 Nested IF functions in data validation. What is the best way around formulas using more than 7 IF functions? How do you write an IF function in VBA where there are more than seven statements? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
| 14 Nested IF statements creating different validation lists | Excel Worksheet Functions | |||
| Complex Vlookup and List Validation and Nested IF statements | Excel Worksheet Functions | |||
| If statements with validation lists | Excel Worksheet Functions | |||
| Data Validation w/ If, Match & Index Statements | Excel Worksheet Functions | |||
![CC[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
