Can ISTEXT display anthing other than True or False?

Quote from slick225

Background: I'm using an ISTEXT formula for open cases to my support group, and I have a column for resolution, and another column for status. I want to formula that will do the following: If there is a resolution (text) in the resolution cell, the status cell will display the text resolved, but if the resolution cell is left blank the status cell should display the text unresolved.

Currently the formula: =ISTEXT(D2) results in True/False

Question:
Can I add to the ISTEXT formula to change the True/False default to Resolved/Unresolved?

use =IF(ISTEXT(D2),"Resolved","Unresolved")

Note: this will return "Resolved" if a space is inadvertently entered in D2

Using =IF(AND(ISTEXT(D2),LEN(D2)>1),"Resolved",Unresolved") will avoid this
HTH

The LEN function checks the length of a text string. In this case, it is checking to see if the length is greater than one (most inadvertant spaces are only one space). The AND forces both conditions (the length greater than 1 and the ISTEXT) to be true in order to get the "Resolved" result.

HTH

My pleasure.