+ Reply to Thread
Results 1 to 5 of 5

Multiple Validations per Cell?

  1. #1
    Registered User
    Join Date
    02-16-2007
    Posts
    58

    Multiple Validations per Cell?

    Is there a way to have a cell check for multiple validations?

    Example:

    First = A validation that makes sure that another cell has the number 4.
    AND
    Second = A validation that requires them to enter a valid time in the cell.

    I can get both of these working seperately but how do I get them to work on the same cell at the same time?

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    Normally you can use the AND() function to combine the two.

    e.g. =AND(Condition1,Condition2)
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    02-16-2007
    Posts
    58

    OK, it is working 50%

    This is what I have so far

    =AND(P4=4,????)

    The ???? needs to have a condition of a valid timed event such as "it took 12:00 minutes to run the report". So I want them ONLY to be able to put in 12:45 and not 1245 or 12 or 45.

    I think you helped me on my other time issue, where I needed time to be something timed and not a time of day. This is for the same sheet.

    By the way thank you so much for your prior help, it works great now!!!!!

    Ken

  4. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    Try:

    =AND(P4=4,A1>=0,A1<=1)

    where A1 is the cell where you're placing the validation function.

    Format the cell as time: hh:mm

  5. #5
    Registered User
    Join Date
    02-16-2007
    Posts
    58

    Thanks

    I am back working on this spreadsheet and your suggestion work great.

    Thanks!
    Ken

+ 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