Forum Discussion
Solved
Check to see if number that is being input it divisible by another cell
Hello, I am having trouble figuring this out, I'm not sure if it is even possible. So I have a range of cells that a customer will be inputting data, this data must meet a full container quantity...
- Use custom this data validation formula in B1:B5, with B1 selected:
=MOD(B1,A$1)=0
This may be your input message:
Enter a number divisible by the number in A1.
Lastly, this may be your error message:
The number you entered is not divisible by the number in A1. Please enter another number.
Use custom this data validation formula in B1:B5, with B1 selected:
=MOD(B1,A$1)=0
This may be your input message:
Enter a number divisible by the number in A1.
Lastly, this may be your error message:
The number you entered is not divisible by the number in A1. Please enter another number.
=MOD(B1,A$1)=0
This may be your input message:
Enter a number divisible by the number in A1.
Lastly, this may be your error message:
The number you entered is not divisible by the number in A1. Please enter another number.
This works great, I was way overthinking it. Thank you for the help!!
- You’re welcome.