Put this in A5
=IF(A3="Orange",3,"Not Orange")

"Tim" wrote:

I have a cell ie. A3 which is a word and I want to tell cell A5 that whenever
it sees this word to asign it a value of 5 foe example.

Orange=3

Is this possible
--
Tim