Trouble with getting excel to choose one text over another to deliver a value

[cndctr]

Hello.

I'm having difficulty with an additive formula based on text in a cell.

A cell may include "finished" or "partially finished." I'm having difficulty with it returning the values for both when it says "partially finished". I need the cell to return one value for "finished" (1) and a different value for "partially finished" (.5). It seems it's finding the words "partially" and "finished" as two separate values and adding both together (1.5) when the cell says "partially finished."

How can I make the cell choose one value?

Thanks from a newbie.

[ragulduy]

have you tried something like:
=IF(ISERROR(SEARCH("partially finished",A1,1)),IF(ISERROR(SEARCH("finished",A1,1)),0,1),0.5)

[cndctr]

Thank you, ragulduy, that works for part of it. The syntax of which I'm uncertain is partially fixed by your suggestion, but I also need to be able to add to that, and that is where there's a comma or parenthesis or something I'm not doing right. In addition to selecting the finished/unfinished, I also need to be able to add to it based on other features, such as exterior access or bathroom rough-in.

In other words, very simply put,

=IF(ISERROR(SEARCH...)) + (IF(ISNUMBER(SEARCH(""Exterior Access",otherpage!BK2,1)),".15","0")) + ((IF(ISNUMBER(SEARCH("bathroom rough-in",otherpage!BK2,1)),".5","0"))

or something like that.

PArt of the issue is that the info on otherpage is imported and all these things come in a single field, so my sheet needs to be able to figure values from a single field and select as well as add. Doable?

Thanks. I know only enough excel as to be a danger to myself and others. Much appreciated!