Excel foruma question

[deadgoodundies]

I'm having a bit of problems using the SUBSTITUTE function

Example I have in A2 & A3 and it's either populated by the words Simple or Configurable
In column B2 I have the the formula =SUBSTITUTE(A2,"simple","No")

Which works fine in that it will replace B2 to say No but I can't work out how to write the formula so that it encompasses both Simple & configurable and Yes & No so I can just copy the forumla down the column

 

[Voicebooth]

=SUBSTITUTE(SUBSTITUTE(A2,"simple", "No"), "configurable", "Yes")

 

[deadgoodundies]

You beaut

 

[MikeJ]

FWIW, you could have just done a search and replace.

 

[deadgoodundies]

Yup but wanted to try and avoid extras steps if possible