CONVERT OR FUNCTION RESULT ON A NUMBER

Hello everybody, I'd like to add a column of results, but only if the content of the cells on the range are coincident with a precise text. I mean, a colum presents text of several types: "CERRADO"...