Closed Thread
Results 1 to 3 of 3

custom data validation

  1. #1
    Registered User
    Join Date
    02-01-2012
    Location
    uae
    MS-Off Ver
    Excel 2003
    Posts
    2

    custom data validation

    Dear Forum user,

    For the sake of maintaining a data list about petty cash expenses. I wanted to use data validation for cell B2, in such a way that it should allow data to be entered into it based on the value in the cell A1, precisely speaking it should only allow data (any data text or number) to be eneterd, if the cell A1 contains any one of the follwing value:

    bills
    payable
    receivable




    I was trying to restrict the values from being enetered into the cell B2 by applying the following formula in the custom data validation.


    =if(a2="bills", true, false)

    but the problem with this formula is it only checks for the value "bills" in cell A1 and i want a formula like multiple if criteria so that it checks for all three values mentioned above (bills, payable and receivable)


    please help

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: custom data validation

    Hi

    Is this the same question??

    http://www.excelforum.com/excel-gene...alidation.html
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: custom data validation

    This is a duplicate of the thread linked by Fotis. This thread is now closed.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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