Excel - Data Validation syntax

Steve-SDC

New member
Joined
Feb 20, 2020
Messages
3
Reaction score
0
Points
0
Excel Version(s)
2001
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?
 

Attachments

  • DV.png
    DV.png
    74 KB · Views: 9
Last edited by a moderator:
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.
 
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
 
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)?
 
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.
 
Back
Top