A
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
--
thanks for the help and time.
aaron
--
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
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
A
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
--
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
--
J
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
--
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
--
J
John Wilson
Aaron,
To answer your direct question......
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
To answer your direct question......
Why certainly.................... take a look here:does anyone know of a workaround to the limit for a nested if.
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
R
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