IF statements

Hello Tracey
Thank you for your question

Try the following formula where you want to check if a cell contains some text:

=IF(ISNUMBER(SEARCH("*dog*",A1)),"dog","")

In this example, if the A1 field contains 'dog' anywhere in the cell then 'dog' will be the result of the formula cell. You can change the second dog in the formula to read 'true' or whatever you want.

If you want to see if the cell starts with 'dog' then in a seperate column (for example column B) use the following formula:

=LEFT(A1,3)

This will return the first three letters of the start of the word. In another colun you can use the following formula:

=IF(B1="dog",TRUE,FALSE)

Dont forget that you can hide some of these columns if you dont want them to be seen. The best way to learn more about formulas and IF statements is the take each problem as it comes and research the formula on the internet as many people have often asked the same question before.

If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress