Data Validation Question
Upcoming Power Excel Seminars
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Data Validation Question

  1. #1
    Guest

    Default

     
    I want cell B2 to have data validation so that number being entered is a number that can be evenly divided by the number in cell A2.

    I'm sure this is an easy one for most of you, but I don't know how to write this formula.

    Thanks for any help.

    Mav.

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,785
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default


    Is that

    =MOD(B2,A2)=0

    what you're looking for?

    If so, you'll need to choose 'Custom' in the Data Validation window and enter the above in the Formula box.

    Aladin

  3. #3
    Guest

    Default

    I'm not sure if that is what I need.

    If I have "10" in A1, I want only numbers divisible by 10 to be allowed in B2.

    And if I change A1 from "10" to "16", only numbers that can be divided by 16 will be allowed in B2.

    Thanks!

    Mav

  4. #4
    Board Regular RichardS's Avatar
    Join Date
    Feb 2002
    Location
    Victoria, Australia
    Posts
    761
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Aladins formula works. Select cell B2, Go to Data menu, select validation. In the allow box choose custom, in the formula box, type Aladin's formula. If you enter 10 in A2, only multiples of 10 can subsequently be entered in B2. If you change A2 to 16, it won't throw up an error immediately if B2 isn't divisible by 16, but if you try to enter a number indivisible ny 16, it will.
    Richard

  5. #5
    Guest

    Default

      
    That works great.

    Thank you both!

    I love this board!. I really learn alot here!

    Mav

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com