Forum Discussion
Solved
IF statement with one set condition and multiple others
In the attached excel sheet. I want to show if a Certificate is required for exporting goods from GB only to the EU or N. Ireland. So basically if goods travel from GB to either the EU or N. Ireland...
=IF(AND(A3="GB",OR(B3={"EU","N. Ireland"})),"Yes","No")
For the field "Is Catch Cert required (Y/N)" it's more logical to have an outputs as Yes/No
Maybe. In general, I try to avoid text because is is so easy to mistype. Here I wrote to the cell with a name "Required?" and used number formatting so that it reads "Yes/No". If there are dependent formulas, they reference the cell using
= IF(required?, AdditionalResources)
rather than
= IF(required="Yes", AdditionalResources)
I seem to remember your saying you prefer 'IsRequired' for Booleans. Either way documentation is needed to help future maintenance.
= IF(required?, AdditionalResources)
rather than
= IF(required="Yes", AdditionalResources)
I seem to remember your saying you prefer 'IsRequired' for Booleans. Either way documentation is needed to help future maintenance.