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

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

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

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

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

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

Data Validation - IF statements
 

This formula creates the frame name in M217.

IF(AND(R17"Material Type",OR(AG17="Hinge type",AG17="Hinge
direction"))"Frame Name",0)

My validation reads

IF(M217="Frame Name",framewhatever) and this creates the list. This works
up to 6 IF statements and then creates an error. I want to be able to
expand this.

Thanks
C

"T. Valko" wrote in message
...
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

Data Validation - IF statements
 

We're not understanding each other!

I understand you have formulas in row 217. A drop down list resides in a
single cell and this list can have only 1 source. If the formulas on row 217
return these values:

blue, red, green, brown

What determines whether you want to use blue, red, green, or brown as the
source of the list? You can only use 1 of them.

Is there anyway that I can see your file? That would give me a better
"picture" of what you're trying to do.


--
Biff
Microsoft Excel MVP


"CC" wrote in message
...
This formula creates the frame name in M217.

IF(AND(R17"Material Type",OR(AG17="Hinge type",AG17="Hinge
direction"))"Frame Name",0)

My validation reads

IF(M217="Frame Name",framewhatever) and this creates the list. This works
up to 6 IF statements and then creates an error. I want to be able to
expand this.

Thanks
C

"T. Valko" wrote in message
...
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