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