Results 1 to 3 of 3

Formulas interfering with check for text

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    4,056

    Formulas interfering with check for text

    I want to check for text in a cell. My formula is
    =IF(ISTEXT(I3),"yes","No")
    However, the cells I want to check are populated with formulas, similar to
    =IF(A3="Bob", G3,"")
    So, I only want to do something with the ones that actually have a value (but it's a name, so text) populating my cells. How do I get my ISTEXT formula to do what I want?

    Thanks in advance,
    John
    Last edited by jomili; 03-30-2011 at 10:25 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1