Hello,

I'm trying to workout a formula to:

- If cell A1 contains the text "test text", then make cell H1 return the word "hello"
- I still want to be able to type other text into cell H1 if required, so I'm not looking at inputting the formula directly into cell H1
- Can I add in a formula into another cell to control cell H1 based on A1's text?