I am struggling with a validation rule. I have two fields "Hours" & "Type". If type = "Float Holiday" I want to make sure that my hours are either 4 or 8 nothing else. Is there a way to write that out? Thanks
1. Give the Hours textbox a name, called Hours, name the Type of PTO dropdown list PTO.
2. Click the Hours textbox and add a Validation rule.
3. In the Formula, key in this formula (you might need to replace the PTO and Hours with the token under the Named Controls tab.
If(PTO == "Float Holiday", If(or(Hours == 4, Hours == 8),false,true), false)
Hope it help.
You can use Formular with same Steps Stephen Saw
(PTO == "Float Holiday") && (Hours != 4 || Hours != 8)
That worked perfect... Thanks
Retrieving data ...