Results 1 to 6 of 6

Thread: Excel - Data Validation syntax

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Neophyte Steve-SDC's Avatar
    Join Date
    Feb 2020
    Posts
    3
    Articles
    0
    Excel Version
    2001

    Excel - Data Validation syntax

    In Excel - I have a simple calculation for Cell K25: =((J22*K24)+1) But I want to enforce a rule on the RESULT: Cell K25 must Also be <= C10 Can you help me with the required syntax/formula/Data Validation for this cell? I can’t get my Data Validation error message to appear?
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	DV.png 
Views:	8 
Size:	74.0 KB 
ID:	9630  
    Last edited by AliGW; 2020-02-21 at 08:10 AM. Reason: Redacted for legibility.

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,710
    Articles
    0
    Excel Version
    365
    You can't do data validation on the result of a formula. However you can do something along the lines of:
    Code:
    =IF((J22*K24)+1<C10,(J22*K24)+1,"Result > " & C10)
    instead.

  3. #3
    Neophyte Steve-SDC's Avatar
    Join Date
    Feb 2020
    Posts
    3
    Articles
    0
    Excel Version
    2001
    Thanks for your response! A User (Sergio) within another forum provided me with a very good solution, allowing me to apply it within 'Data Validation' with this syntax: =($J$22*$K$24+1) <=C10

    Steve

  4. #4
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,710
    Articles
    0
    Excel Version
    365
    I don't think that data validation in cell K25 (what you asked for) will do anything, so I'm guessing you've put that data validation in other cells (J22 and /or K24)?

  5. #5
    Neophyte Steve-SDC's Avatar
    Join Date
    Feb 2020
    Posts
    3
    Articles
    0
    Excel Version
    2001
    Correct!

  6. #6
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,402
    Articles
    0
    Excel Version
    Office 365 Subscription
    Steve - the forum rules require you to provide cross-post links if you have posted the same query elsewhere. Please add a link to the solution you were given. If you do this again, please provide the links up front. Thanks.
    Ali
    Enthusiastic self-taught user of MS Excel!

Tags for this Thread

Posting Permissions

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