Hi all,
I've got 9 questions with a text box, drop down response and I need all to be filled in and not left blank. However, I have a 2-part questions where the 2nd part only appears if 'Not Available' is selected in the 1st part.
I'm trying to validate the page as complete but need to discount the 2nd part of the question if 'Not available' is selected and visa versa.
Is there a way to us the 'And' and 'Or' expressions in one expression? like Or((And(A1 ="Not Available",A2 !=""),And(A1 !="Not Available",A2 'does not appear')?
Sorry if thats written completely incorrectly, the idea is if A1 contains 'Not Available' then A2 cannot be blank or A1 does not equal 'Not Available' and A2 doesn't appear then show as complete.
Any help would be great
Thanks
Blake