+ Reply to Thread
Results 1 to 2 of 2

Validation Rule

  1. #1
    Registered User
    Join Date
    02-05-2016
    Location
    Amsterdam
    MS-Off Ver
    Excel 10
    Posts
    2

    Question Validation Rule

    Hey there,

    I have an inventory document that contain various sheets. Each sheet represents a card of an item.
    One of the fileds on each sheet as Current Inventory of that item.

    On that sheet I made a form where the user can indicate how many of that item s/he has taken.
    a validation rule is set to guard that the user cannot take more than what is available.

    For example:
    G8 = current invetory amount
    B12...Bn = are the cells where a user will indicate an amount taken

    G8= 23,6 (initially)
    B12=23 (G8 is now 0,6)
    B13 = 0,3 (G8= now 0,3)
    B14 = 12 (error message should appear)

    I used this formula in the validation rule window: =$G$8-$B12 >=0
    But it does not work well

    How can I solve this best way?
    Thank you,

  2. #2
    Registered User
    Join Date
    02-05-2016
    Location
    Amsterdam
    MS-Off Ver
    Excel 10
    Posts
    2

    Re: Validation Rule

    When I test this again, even when I enter in B12 23 I get an error message - so the formula I use is not reliable

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. excel validation rule
    By Dan107 in forum Excel General
    Replies: 2
    Last Post: 09-09-2015, 05:24 PM
  2. Validation Rule Help
    By dangoodwin1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-31-2012, 04:22 PM
  3. data validation-setup a validation rule
    By de049 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-07-2008, 08:17 AM
  4. If statement & validation rule
    By stoney1977 in forum Excel General
    Replies: 1
    Last Post: 09-30-2007, 03:19 PM
  5. [SOLVED] Validation rule
    By nick in forum Excel General
    Replies: 4
    Last Post: 03-06-2006, 01:00 PM
  6. validation rule
    By andrewm in forum Excel Formulas & Functions
    Replies: 49
    Last Post: 09-06-2005, 12:05 PM
  7. Validation rule but only sometimes
    By Broida (spamless) in forum Excel General
    Replies: 8
    Last Post: 06-26-2005, 06:05 PM

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