software

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=quot;Default Template Windows 2003 Member
Serverquot;,quot;DEFAULT-YESquot;,IF(A3=quot;Default Template Windows 2000 Domain
Controllerquot;,quot;DEFAULT-YESquot;,IF(A3=quot;Default Template Windows 2003 Domain
Controllerquot;,quot;DEFAULT-YESquot;,IF(A3=quot;Default Template Windows 2000 Member
Serverquot;,quot;DEFAULT-YESquot;,IF(A3=quot;Default Template Windows 2000 Cluster
Serverquot;,quot;DEFAULT-YESquot;,IF(A3=quot;Default Template Windows 2003 Cluster
Serverquot;,quot;DEFAULT-YESquot;,IF(A3=quot;Default Template Windows 2000 Member
Server IISquot;,quot;DEFAULT-YESquot;,IF(A3=quot;Customquot;,quot;NOquot;))))))))

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: www.excelforum.com/member.php...oamp;userid=30000
View this thread: www.excelforum.com/showthread...hreadid=497646The maximum number of nested IF statements is 7 (or 8, depending on how
they are counted). If you have more conditions then the VLOOKUP( )
function can be used in conjunction with a table of available values
and outcomes.

PeteYou could use something such as:

=IF(OR(A3=quot;Default Template Windows 2003 Member Serverquot;,A3=quot;Default Template
Windows 2000 Domain Controllerquot;,A3=quot;Default Template Windows 2003 Domain
Controllerquot;,A3=quot;Default Template Windows 2000 Member Serverquot;,A3=quot;Default
Template Windows 2000 Cluster Serverquot;,A3=quot;Default Template Windows 2003
Cluster
Serverquot;,A3=quot;Default Template Windows 2000 Member Server
IISquot;),quot;DEFAULT-YESquot;,IF(A3=quot;Customquot;,quot;NOquot;))

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 quot;Falsequot;. If
you want it to return something else, such as quot;No Matchquot;, then use the
following.

=IF(OR(A3=quot;Default Template Windows 2003 Member Serverquot;,A3=quot;Default Template
Windows 2000 Domain Controllerquot;,A3=quot;Default Template Windows 2003 Domain
Controllerquot;,A3=quot;Default Template Windows 2000 Member Serverquot;,A3=quot;Default
Template Windows 2000 Cluster Serverquot;,A3=quot;Default Template Windows 2003
Cluster Serverquot;,A3=quot;Default Template Windows 2000 Member Server
IISquot;),quot;DEFAULT-YESquot;,IF(A3=quot;Customquot;,quot;NOquot;,quot;No Matchquot;))

HTH,
Paul

quot;EdoZwartquot; gt; wrote in
message ...
gt;
gt; HELP!
gt;
gt; as a sort of beginner finaly using the =IF command and is working fine.
gt; BUT.....i try to add some more if commands in one line but it doesn't
gt; work:
gt;
gt; =IF(A3=quot;Default Template Windows 2003 Member
gt; Serverquot;,quot;DEFAULT-YESquot;,IF(A3=quot;Default Template Windows 2000 Domain
gt; Controllerquot;,quot;DEFAULT-YESquot;,IF(A3=quot;Default Template Windows 2003 Domain
gt; Controllerquot;,quot;DEFAULT-YESquot;,IF(A3=quot;Default Template Windows 2000 Member
gt; Serverquot;,quot;DEFAULT-YESquot;,IF(A3=quot;Default Template Windows 2000 Cluster
gt; Serverquot;,quot;DEFAULT-YESquot;,IF(A3=quot;Default Template Windows 2003 Cluster
gt; Serverquot;,quot;DEFAULT-YESquot;,IF(A3=quot;Default Template Windows 2000 Member
gt; Server IISquot;,quot;DEFAULT-YESquot;,IF(A3=quot;Customquot;,quot;NOquot;))))))))
gt;
gt; Does anyone know what the problem can be or another solution? Is there
gt; a maximum of characters or something?
gt;
gt; Thanks in advanced!
gt;
gt; Edo
gt;
gt;
gt; --
gt; EdoZwart
gt; ------------------------------------------------------------------------
gt; EdoZwart's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30000
gt; View this thread: www.excelforum.com/showthread...hreadid=497646
gt;
Your function can be simplified, as follows:

=IF(LEFT(A3,7)=quot;Defaultquot;,quot;DEFAULT-YESquot;,IF(A3=quot;Customquot;,quot;NOquot;,quot;Not
specifiedquot;))

At present you do not specify what should happen if A3 contains any
other values than those in your formula, so this version makes this
clearer.

PetePete,

Though your formula is much simpler, it would not be effective if A3
contained quot;Default Template Windows XP Member Serverquot; or any other data
(other than what Edo specified) that begins with quot;Defaultquot;.

The second formula that I provided does, in fact, specify what will happen
when nothing matches the values in the formula. I also explained that the
first formula would return quot;Falsequot; should A3 not match any of the values
specified in the formula. The second formula would return quot;No Matchquot; when
there was no match.

Regards,
Paul

quot;Petequot; gt; wrote in message oups.com...
gt; Your function can be simplified, as follows:
gt;
gt; =IF(LEFT(A3,7)=quot;Defaultquot;,quot;DEFAULT-YESquot;,IF(A3=quot;Customquot;,quot;NOquot;,quot;Not
gt; specifiedquot;))
gt;
gt; At present you do not specify what should happen if A3 contains any
gt; other values than those in your formula, so this version makes this
gt; clearer.
gt;
gt; Pete
gt;

Thanks for al the reply's! I have setup the excel sheet with vlookup and
is working a lot easier.--
EdoZwart
------------------------------------------------------------------------
EdoZwart's Profile: www.excelforum.com/member.php...oamp;userid=30000
View this thread: www.excelforum.com/showthread...hreadid=497646