My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 IF
|
|
 Jun 19 2006, 06:25 AM
Post
#1
|
|
|
UtterAccess Veteran Posts: 429 From: UK  |
What is the maximumum number of IF statements you can use in one cell?
i.e. =IF('\\Lancelot\Live Exhibits\Botanical\Timesheet Check\Tom Pitman\[Timesheet.xls]wtd'!B5=0,1,IF('\\Lancelot\Live Exhibits\Botanical\Timesheet Check\Tom Pitman\[Timesheet.xls]wtd'!B11="OFF",1,IF('\\Lancelot\Live Exhibits\Botanical\Timesheet Check\Tom Pitman\[Timesheet.xls]wtd'!B11="AL",1,IF('\\Lancelot\Live Exhibits\Botanical\Timesheet Check\Tom Pitman\[Timesheet.xls]wtd'!B11="Lieu Time",1,IF('\\Lancelot\Live Exhibits\Botanical\Timesheet Check\Tom Pitman\[Timesheet.xls]wtd'!B11="BH",1,IF('\\Lancelot\Live Exhibits\Botanical\Timesheet Check\Tom Pitman\[Timesheet.xls]wtd'!B11="2Hrs",4,IF('\\Lancelot\Live Exhibits\Botanical\Timesheet Check\Tom Pitman\[Timesheet.xls]wtd'!B11="Xmas Day",1,IF('\\Lancelot\Live Exhibits\Botanical\Timesheet Check\Tom Pitman\[Timesheet.xls]wtd'!B10>0,2,3)))))))) I want to add one more IF, but I receive a formula error. |
 |
 
|
|
Jun 19 2006, 06:26 AM
Post
#2
|
|
|
Retired Moderator Posts: 10,959 From: Prague,CZ / Kiev,UA |
7
Martin |
|
|
|
|
Jun 19 2006, 06:51 AM
Post
#3
|
|
|
UtterAccess Veteran Posts: 429 From: UK |
Strange, The formula above has 8 and works, I need to add another IF statement.
|
|
|
|
|
Jun 19 2006, 08:08 AM
Post
#4
|
|
|
Retired Moderator Posts: 10,959 From: Prague,CZ / Kiev,UA |
Hello again,
there is a limit of 7 nested IFs: http://support.microsoft.com/kb/214154/en-us I didn't examine your formula thoroughly, may be thzat not all the 8 iFs are nested... You may need some workaround formula to overcome this problem. Martin |
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 23rd May 2013 - 06:53 PM |