nathan2314
07-15-2008, 10:10 AM
Hi all,:hi:
I'm trying to write a formula in a cell that is pretty straight forward. It just has a bunch of IF statements. The problem is that when I get to a certain number of IF statements the formula stops working. I'm guessing there is a limit to the number of IF statements allowed? Is there another way of doing it? What I'm trying to do is set the value of the cell based off of a value selected by a user in a drop down combo box. When the use makes his/her selection, this cell will be shifted on value off in the list. code below...
=if(AB1="ALL","E6",if(AB1="E6","E5",if(AB1="E5","E4",if(AB1="E4","E3",if(AB1="E3","E2",if(AB1="E2","E1",if(AB1="E1","O6",if(AB1="O6","O5",if(AB1="O5","O4",if(AB1="O4","O3",if(AB1="O3","O2","")))))))))))
Apprectiate any help !! :bow:
I'm trying to write a formula in a cell that is pretty straight forward. It just has a bunch of IF statements. The problem is that when I get to a certain number of IF statements the formula stops working. I'm guessing there is a limit to the number of IF statements allowed? Is there another way of doing it? What I'm trying to do is set the value of the cell based off of a value selected by a user in a drop down combo box. When the use makes his/her selection, this cell will be shifted on value off in the list. code below...
=if(AB1="ALL","E6",if(AB1="E6","E5",if(AB1="E5","E4",if(AB1="E4","E3",if(AB1="E3","E2",if(AB1="E2","E1",if(AB1="E1","O6",if(AB1="O6","O5",if(AB1="O5","O4",if(AB1="O4","O3",if(AB1="O3","O2","")))))))))))
Apprectiate any help !! :bow: