There is a limit of 7 nested IFs.
But it would be far better and easier to read if you used the VLOOKUP()
function.
Look in HELP for details, post again in this thread if you still have
problems.

--
Kind regards,

Niek Otten

"bufossil" wrote in message
...
I am listing a number of deliverables, and want the deadlines for those
deliverables to automatically appear in the next column (I have the
deadlines
on a tab named "Lists"). Unless I am misunderstanding something, there is
a
limit of 7 successive IF-THEN statements you can use. Here is my IF-THEN
formula:

=IF(E4="User Guide",'Lists'!D4,IF(E4="Installation",'Lists'!D5, IF(E4="HW
Upgrade",'Lists'!D3,IF(E4="Maintenance",'Lists'!D6 ,IF(E4="RAS
Trouble",'Lists'!D3,IF(E4="Online Help",'Lists'!D2,IF(E4="Site
Prep",'Lists'!D7,IF(E4="Inventry Sheet",'Lists'!D10,IF(E4="SW
Upgrade",'Lists'!D9,IF(E4="Release Notes","",IF(E4="Many or
All","",IF(E4="Other or N/A","",""))))))))))))

Excel will not let me use the formula because it has issues with the 8th
IF-THEN statement. My guess is that Excel can only handle 7. Does anyone
know the limit you can use? I have 12 different values that have
different
deadlines. Thanks!