Results 1 to 26 of 26

Add Second Function To Validation Formula

Threaded View

  1. #1
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Question Add Second Function To Validation Formula

    I'm trying to get a validation formula to work with Cell I2. It needs to check the number entered to make sure there is no dash, which is working with this formula:

    =IF(ISNUMBER(SEARCH("-",I2)),FALSE, TRUE)

    I'm trying to expand that formula to also check if there's a dash in Cell C2, and not allow the value to be entered in Cell I2 if there is a value without one.

    So basically, it needs to make sure there is no dash in the value entered into Cell I2, and that if Cell C2 has a value, it includes a dash. (If there is no value in Cell C2, then no dash doesn't matter.)

    How would I be able to make this work?
    Last edited by Leith Ross; 04-03-2012 at 12:12 PM. Reason: Removed Quote Tag around the formula
    There is so much good in the worst of us,
    And so much bad in the best of us,
    That it hardly behooves any of us
    To talk about the rest of us.

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