Pete,

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

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 "False" should A3 not match any of the values
specified in the formula. The second formula would return "No Match" when
there was no match.

Regards,
Paul

"Pete" wrote in message
oups.com...
Your function can be simplified, as follows:

=IF(LEFT(A3,7)="Default","DEFAULT-YES",IF(A3="Custom","NO","Not
specified"))

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.

Pete