You could use something such as:
=IF(OR(A3="Default Template Windows 2003 Member Server",A3="Default Template
Windows 2000 Domain Controller",A3="Default Template Windows 2003 Domain
Controller",A3="Default Template Windows 2000 Member Server",A3="Default
Template Windows 2000 Cluster Server",A3="Default Template Windows 2003
Cluster
Server",A3="Default Template Windows 2000 Member Server
IIS"),"DEFAULT-YES",IF(A3="Custom","NO"))
This formula will do what you want. However, if A3 does not include one of
the values specified in your formula, then the result will be "False". If
you want it to return something else, such as "No Match", then use the
following.
=IF(OR(A3="Default Template Windows 2003 Member Server",A3="Default Template
Windows 2000 Domain Controller",A3="Default Template Windows 2003 Domain
Controller",A3="Default Template Windows 2000 Member Server",A3="Default
Template Windows 2000 Cluster Server",A3="Default Template Windows 2003
Cluster Server",A3="Default Template Windows 2000 Member Server
IIS"),"DEFAULT-YES",IF(A3="Custom","NO","No Match"))
HTH,
Paul
"EdoZwart" wrote in
message ...
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