+ Reply to Thread
Results 1 to 3 of 3

Nested data validation?

  1. #1
    Registered User
    Join Date
    12-16-2008
    Location
    Minneapolis
    Posts
    16

    Nested data validation?

    Geniuses-

    I'm trying to figure a to enforce dual data validation on a single cell. That is, I need to restrict the user to entering only a decimal value, only if a particular other cell (say A2) is blank. To put it another way, if A2 is blank, the user can enter a decimal value, but if A2 is not blank, the user cannot enter anything.

    I can use Data Validation to enforce either the decimal restriction or the ISBLANK, but I'm not sure how to make them work together. Is anyone able to make a suggestion?

    Thanks in advance,
    Joe in MN
    Last edited by splenguin; 09-03-2009 at 11:13 AM.

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Nested data validation?

    Using the Custom option, this formula:

    =AND(ISBLANK(A2)=TRUE,ISNUMBER(A1))

  3. #3
    Registered User
    Join Date
    12-16-2008
    Location
    Minneapolis
    Posts
    16

    Re: Nested data validation?

    PERFECT. Thanks a million-

    joe

+ 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