Forum Discussion

Steve-SDC's avatar
Steve-SDC
Copper Contributor
Feb 20, 2020
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...
excel
PReagan's avatar
PReagan
Bronze Contributor
Feb 20, 2020

Hello Steve-SDC,

 

Try to recalculate the cell with data validation after you set the data validation. If you set the data validation after you already calculated the cell, then it will not show an error.

Steve-SDC's avatar
Steve-SDC
Copper Contributor
Feb 20, 2020
Thanks - tried that. Still did not work. I want the User to manually enter J22 and K24. The Result is calculated to K25. But I want an error message (or dis-allow K25 to be populated) IF K25 is > C10.
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Feb 20, 2020

    Steve-SDC 

    Let assume we have correct result at the beginning

    Now we are truing to enter 55 into K24

    With this we have two options - enter correct value to K24 or cancel and return back to initial data.

    Or I misunderstood and you consider another scenario?

    • Steve-SDC's avatar
      Steve-SDC
      Copper Contributor
      Feb 20, 2020

      Yes, the example you have shown matches mine, but I am not getting the error flagged properly SergeiBaklan 

    • Steve-SDC's avatar
      Steve-SDC
      Copper Contributor
      Feb 20, 2020

      SergeiBaklan 

      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

Resources