Fellow Forum Members.
The function below is my horrific attempt at figuring it out on my own and I should point out it does not work:
=IF(NOT(ISERROR(FIND("Cell Empty or Cell Full",A1))),"Condition 1 Txt", "Condition 2 Txt","")
What I'm trying to develop is a function that checks for two conditions in Cell A1.
The first condition to check is if Cell A1 is devoid of data. If cell A1 is empty it returns "Condition 1 Txt" to the cell where the formula resides.
The second condition to check is if Cell A1 is occupied with data. If cell A1 is contains any kind of data it returns the text "Condition 2 Txt" to the cell where the formula resides.
The text string "Condition 1 Txt" and "Condition 2 Txt" are just examples. I plan to replace both with different text messages.
Any help will be greatly appreicated. Thanks
The function below is my horrific attempt at figuring it out on my own and I should point out it does not work:
=IF(NOT(ISERROR(FIND("Cell Empty or Cell Full",A1))),"Condition 1 Txt", "Condition 2 Txt","")
What I'm trying to develop is a function that checks for two conditions in Cell A1.
The first condition to check is if Cell A1 is devoid of data. If cell A1 is empty it returns "Condition 1 Txt" to the cell where the formula resides.
The second condition to check is if Cell A1 is occupied with data. If cell A1 is contains any kind of data it returns the text "Condition 2 Txt" to the cell where the formula resides.
The text string "Condition 1 Txt" and "Condition 2 Txt" are just examples. I plan to replace both with different text messages.
Any help will be greatly appreicated. Thanks