+ Reply to Thread
Results 1 to 4 of 4

Require a cell to be valued based on another cell

  1. #1
    Registered User
    Join Date
    05-21-2005
    Posts
    4

    Require a cell to be valued based on another cell

    I'm trying to require text to be entered in cell B1 if there is text in cell A1.

    This below formula seems to be close, in that it is giving me TRUE or FALSE, but if it is true i don't want it to display anything, if it is false, I want it to display "Cell B1 must be valued"

    =IF(ISTEXT(A1),ISTEXT(B1),"Cell B1 must be valued")

  2. #2
    Forum Contributor
    Join Date
    06-10-2004
    Location
    India
    Posts
    1,066
    Select cell B1, Click Data > Validation. Select custom, and enter the formula:
    =IF(ISTEXT(A1),ISTEXT(B1))

    Mangesh

  3. #3
    Registered User
    Join Date
    05-21-2005
    Posts
    4

    Thumbs down

    Quote Originally Posted by mangesh_yadav
    Select cell B1, Click Data > Validation. Select custom, and enter the formula:
    =IF(ISTEXT(A1),ISTEXT(B1))

    Mangesh

    That only works if someone selects cell B1. Also, I'm already doing data validation on B1 (a List validation)

  4. #4
    Forum Contributor
    Join Date
    06-10-2004
    Location
    India
    Posts
    1,066
    =IF(AND(ISTEXT(A1),ISTEXT(B1)),"","Cell B1 must be valued")
    or
    =IF(ISTEXT(A1),IF(ISTEXT(B1),"","Cell B1 must be valued"),"")
    (the second one checks only if a1 is text)

    Mangesh
    Last edited by mangesh_yadav; 05-21-2005 at 01:19 AM.

+ Reply to Thread

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