LinkBack URL
About LinkBacks
I am trying to combine 2 IFs statement together to get 1 IF.
The reason I need 2 IFs is cos excel only allows a max number of nested IFs in one cell.
Does anyone know the solution? Or is there a better way of doing it?
I am trying to combine 2 IFs statement together to get 1 IF.
The reason I need 2 IFs is cos excel only allows a max number of nested IFs in one cell.
Does anyone know the solution? Or is there a better way of doing it?
Hi,
XL versions prior to 2007 allow 7 embedded IF's.2007 much more
Please add a small sample of your data and what you are trying to achieve
(If you use the forum's search function on "embedded ifs" you'll find lots of answers)
Hi Arthur, I am on excel 2003.Originally Posted by arthurbr
For example
cell A1 if(x>1,1,if(x>2,2,if(x>3,3,if(x>4,4,if(x>5,5,if(x>6,6,7))))))
cell A2 if(x>7,1,if(x>8,2,if(x>9,3,if(x>10,4,if(x>11,5,if(x>12,6,7))))))
cell A3 to combine results of A1 and A2
Or is there a better way of doing it?
Your formula won't work because everything will be 1.
If you enter i.e. 5 he will look first IF statement (is 5>1, TRUE-> result is 1).
Maybe you want:
=ROUNDDOWN(B1;0)
or this =MIN(7;ROUNDDOWN(B1;0))
(replace ; with , if needed)
Never use Merged Cells in Excel
For second example you might want to consider this formula:
=LOOKUP(B2;{7;8;9;10;11;12};{1;2;3;4;5;6})
Sorry the values are arbritrary. I was trying to illustrate joining the 2 IFs statement.
Combination of all, as I get it right, is slightly different:
=IF(B1>13;7;ROUNDDOWN(MOD(B3-1;6)+1;0))
I try to ilustrate that instead of using dosen of IF's you might consider other solutions
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks