If Cell A is displaying street directions and I want Cell B to give me a value of true if there is anything in cell A how would I write the formula? So far I have =ISBLANK(A2). When I type that in I want to get back the value "TRUE" If there is nothing in CellA then I want to get the value "FALSE".
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel Formula 1
- Thread starter dwayne94
- Start date
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
Don't let the Diatribe...![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
- Status
Similar threads
- Locked
- Question