Thread: =IF problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
EdoZwart
 
Posts: n/a
Default =IF problem


HELP!

as a sort of beginner finaly using the =IF command and is working fine.
BUT.....i try to add some more if commands in one line but it doesn't
work:

=IF(A3="Default Template Windows 2003 Member
Server","DEFAULT-YES",IF(A3="Default Template Windows 2000 Domain
Controller","DEFAULT-YES",IF(A3="Default Template Windows 2003 Domain
Controller","DEFAULT-YES",IF(A3="Default Template Windows 2000 Member
Server","DEFAULT-YES",IF(A3="Default Template Windows 2000 Cluster
Server","DEFAULT-YES",IF(A3="Default Template Windows 2003 Cluster
Server","DEFAULT-YES",IF(A3="Default Template Windows 2000 Member
Server IIS","DEFAULT-YES",IF(A3="Custom","NO"))))))))

Does anyone know what the problem can be or another solution? Is there
a maximum of characters or something?

Thanks in advanced!

Edo


--
EdoZwart
------------------------------------------------------------------------
EdoZwart's Profile: http://www.excelforum.com/member.php...o&userid=30000
View this thread: http://www.excelforum.com/showthread...hreadid=497646