Forum Discussion
Steve-SDC
Feb 20, 2020Copper Contributor
Excel - Data Validation
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 require...
- Feb 20, 2020
Steve-SDC
Feb 20, 2020Copper Contributor
You Da Man!! Thanks so much. My Problem: I selected both J22 and K24 and Jointly set the Data Validation parameters. Once that I Cleared DV, then re-set the DV Parameters individually for each cell, it works! I am (obviously) not that well-versed with formulas - I really appreciate your patience and sending an Excel file as an example. THANKS AGAIN!!
Steve
SergeiBaklan
Feb 20, 2020Diamond Contributor
Steve, great to know you sorted this out, glad to help.