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.