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...
Thanks Sergio, but that didn't do it - the recommended syntax meant it just used the value for cell C10 since it was the MIN (lower) of the 2. I need to Check/validate that my calculation is Less Than C10 - by sending an error message, Tried to use Data Validation but can't get it to work?
As variant and if J22 and K24 are entered manually, you may apply to each of above cells data validation with the formula
=($J$22*$K$24+1) <=C10- Sergio, do you mean use that syntax in the Data Validation box? If I use it in cells J22 and K24 I can no longer enter them manually. I want the User to enter them manually - and simply check after they have been entered by using K25 for multiplying them, result of K25 must be <= C10. ??
I mean such data validation
for both cells. User could enter to these cell manually any values, and they will receive alert if formula calculation result exceed value of the cell C10.