1 person found this helpful
You can change:
if (event.value>0 && event.value<100)
However, you need to think about this carefully. The second error message will be displayed even while the user is filling in the fields, and that can be very annoying...
Thanks! I agree that the second message can be annoying. I've been debating not using it. Maybe I'll include it in the first message as a reminder.
I don't know your document is supposed to work, but if you have four fields and the user must fill in all four you can only show the <100 error message when all four fields are filled-in and the result is not 100.
They can fill some or all of the boxes, until they get to 100%. So if they use 100% in the first box or 50% on the first two boxes they're done. I was trying to figure out a formula that ignores at least the first box.