Forum Discussion
Solved
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...
Sergio - Thanks Again! I selected both J22 & K24, then applied the formula to both, but as example shows, it still allowed K25 to exceed value of C10? See attached image which shows the Cells and DV box
Steve
Steve, great to know you sorted this out, glad to help.
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