# Can ISTEXT display anthing other than True or False?

• 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?

• 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

• Brandtrock thanks, I used the formula =IF(ISTEXT(D2),"Resolved","Unresolved")
It was exactly what I needed.

I was curious about the 2nd formula: =IF(AND(ISTEXT(D2),LEN(D2)>1),"Resolved",Unresolved")

What is LEN? or what does it do?

• 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

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!