If or formula help for 3 possible outcomes

good morning! I need a little help please with a formula.

i have an argument with three possible outcomes; yes, no, or either yes or no. I'll explain. when calculating VAT (value added tax) we do one of three things.

1.) internal events have no VAT added

2.) corporate events have VAT added

3.) University events have VAT added unless they complete an exemption form for educationally related events. Therefore University events could either be yes or no within the argument/formula.

My form has a drop-down box in A1 where they select which of the above three events they would like to book. depending on their answer, my form will calculate VAT accordingly.

The formula for calculating VAT is elsewhere on the form but refers to cell A1 or C1 for instruction (see below).

With the third option (University events), I would like the form to calculate based on a separate cell (C1) which has a simple dropdown box with either "yes" or "no" which corresponds to a question on VAT exemption status.

Example: The customer chooses option 3 "University Event" which means VAT could, or could not be applicable.

Cell B1 contains some text such as "is your event educational related?"

cell C1 would contains a drop-down with "yes" or "no" The answer to this would be the third possible outcome of the formula discussed above.

it would be great if the text in cells B1 and C1 could be hidden and only revealed if the customer chooses University event from the drop down box in cell A1 (this would save possible confusion or questions from corporate customers!)

any help would be much appreciated. sorry if I've poorly explained; happy to try again!

Hi,

Does the attached help?

Select from A1.

B1 is a formula, C1 is a Data validation and also a conditional format which paints the background and font as white if university in A1 is not selected.

this is what I would put in B1 =IF(A1="university","is your event educational?","")
then this in another cell =IF(AND(A1="university",C1="yes"),"yes",IF(A1="coroporate","yes","no"))

mine should work now, I misspelled corporate in my first version.
this is what I would put in B1 =IF(A1="university","is your event educational?","")
then this in another cell =IF(AND(A1="university",C1="yes"),"yes",IF(A1="corporate","yes","no"))

Great, glad I could help and thank you for the rep!