nested if limit

[Aaron]

hey everyone. does anyone know of a workaround to the limit for a nested if. my understanding is it caps at 7.

thanks for the help and time.

aaron

--

 

[Ron Rosenfeld]

hey everyone. does anyone know of a workaround to the limit for a nested if. my understanding is it caps at 7.

thanks for the help and time.

aaron

Usually there is another, more efficient method of solving the problem.
Perhaps if you post what you're trying to accomplish, someone will be able to
help.


--ron

 

[Aaron]

thanks. if have a sheet set up like this(Class Schedule):

Period 1
600 math
Mr.Smith
Rm.100

601 Science
Ms.Jones
Rm.101

602 English
Mr.Bill
Rm.102

and so on for 9 total classes. 600, 601, 601 represent classes. Each
teacher only teaches one class at a time.

From another sheet(Teacher Schedules), I need to look through the column
labeled Period 1, find a particular teacher's name, then copy the number of
the class that they are teaching. Like this:

Mr.Bill 602
Rm.102

Ms.Jones 601
Rm.101

Mr.Smith 600
Rm.100

Can anyone help? Your time is much appreciated!

Aaron

--

 

[John]

Aaron,

Try using "Names" to split up the "If's" into smaller segments.

i.e. Insert - Name - Define.

regards,

John
hey everyone. does anyone know of a workaround to the limit for a nested if. my understanding is it caps at 7.

thanks for the help and time.

aaron

--

 

[John Wilson]

Aaron,

To answer your direct question......

does anyone know of a workaround to the limit for a nested if.

Why certainly.................... take a look here:
http://www.cpearson.com/excel/nested.htm

BUT........................

I'll have to agree with Ron that "Usually there is another,
more efficient method of solving the problem."

John

 

[Ron Rosenfeld]

thanks. if have a sheet set up like this(Class Schedule):

Period 1
600 math
Mr.Smith
Rm.100

601 Science
Ms.Jones
Rm.101

602 English
Mr.Bill
Rm.102

and so on for 9 total classes. 600, 601, 601 represent classes. Each
teacher only teaches one class at a time.

From another sheet(Teacher Schedules), I need to look through the column
labeled Period 1, find a particular teacher's name, then copy the number of
the class that they are teaching. Like this:

Mr.Bill 602
Rm.102

Ms.Jones 601
Rm.101

Mr.Smith 600
Rm.100

Can anyone help? Your time is much appreciated!

Aaron

Aaron,

I have some questions about your data layout, but if Harlan's answer works for
you, then my questions are irrelevant, so ignore them.

But I think my questions could be answered if you could show the data for both
the first and second periods, and clearly indicate the column breaks.


--ron