Yes, I understand what you're trying to achieve. Here's how you can do it:
- Select the cell where you want to display the result.
- Type the following formula:
Formula:
=IF(OR(ISNUMBER(SEARCH("Check",A1)),ISNUMBER(SEARCH("Checking",A1))),"Checking","Doing")
Note: Replace "A1" with the cell reference of the cell you want to check for the presence of "Check" or "Checking".
- Press Enter.
This formula uses the
IF function to check if the cell contains either "Check" or "Checking". If it does, it returns "Checking". If it doesn't, it returns "Doing". The
OR function is used to check if either "Check" or "Checking" is present in the cell. The
ISNUMBER function is used to check if the
SEARCH function returns a number (which indicates that the text was found).
You can then copy this formula to other cells in the row to check for the presence of "Check" or "Checking" in those cells as well.