"Trainee" wrote:
If A1= blank, then B1= blank
If A1= "green" or "blue" or "plant" or "street" (TEXT),then B1 will show
letter "f".(all examples without quotation of course)
If A1= any other different word, then B1= blank.

You have over-specified the requirements. In B1, the following is
sufficient:

=if(OR(A1={"green","blue","plant","street"}), "f", "")

The quotes are required around string constants. They will not appear, and
they will not be considered part of the text.

PS: Note that you cannot leave B1 "blank" (empty), if by that you mean that
ISBLANK(B1) returns TRUE. But B1="" will be true, whether B1 is empty (no
formula and no constant value) or the null string (""). ISBLANK is a
misnomer :-(.


----- original message -----

"Trainee" wrote in message
...
Could somebody be so kind and provide me with a formula to go in
B1 that will change this cell accordinly to A1.
If A1= blank, then B1= blank
If A1= "green" or "blue" or "plant" or "street" (TEXT),then B1 will show
letter "f".(all examples without quotation of course)
If A1= any other different word, then B1= blank.
Thank you very much.