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.