+ Reply to Thread
Results 1 to 2 of 2

Data Validation using IsNumber and IsBlank

  1. #1
    Forum Contributor
    Join Date
    09-19-2004
    Location
    Canada
    Posts
    408

    Question Data Validation using IsNumber and IsBlank

    Hi everyone,

    I am trying to set up a data validation but it's not working as expected.

    There cannot be an entry in cell A1 when cell B1 in not blank, and when cell B1 is blank any entry in cell A1 must be a number.

    I entered custom formula =AND(ISNUMBER(A1),ISBLANK(B1)). Cell B1 is blank, but when I enter VOID in cell A1 it accepts it and does not give an error. Is my formula incorrect? What should I enter to accomplish this?

    Thank,
    Gos-C
    Using Excel 2010 & Windows 10
    "It is better to be prepared for an opportunity and not have one than to have an opportunity and not be prepared."

  2. #2
    Forum Contributor
    Join Date
    09-19-2004
    Location
    Canada
    Posts
    408

    Smile

    I got it solved. Uncheck Ignore Blank.

    Thanks,
    Gos-C

+ 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