IF OR Statement Errors

Question

I am trying to create a formula that if a supplier name is equal to XXX, XXX, or XXX then check the supplier requires legal review box, however I keep getting different errors. Here is my current formula, any advice?

If(&nbsp; &nbsp; &nbsp; &nbsp; [Supplier] = "Workday" OR&nbsp; &nbsp; &nbsp; &nbsp; [Supplier] = "Amadeus" OR&nbsp; &nbsp; &nbsp; &nbsp; [Supplier] = "Flightkeys" OR&nbsp; &nbsp; &nbsp; &nbsp; [Supplier] = "Google"&nbsp; &nbsp; ,&nbsp; &nbsp; true,&nbsp; &nbsp; false)

I have also tried:
If(&nbsp; &nbsp; Or(&nbsp; &nbsp; &nbsp; &nbsp; [Supplier] = "Workday",&nbsp; &nbsp; &nbsp; &nbsp; [Supplier] = "Amadeus",&nbsp; &nbsp; &nbsp; &nbsp; [Supplier] = "Flightkeys",&nbsp; &nbsp; &nbsp; &nbsp; [Supplier] = "Google"&nbsp; &nbsp; ),&nbsp; &nbsp; true,&nbsp; &nbsp; false)------------------------------Elizabeth Schlagel------------------------------

personal_taxtea · Answer

Make sure the field type for your check box is Formula Checkbox" whcih is sounds like it already is and then the formula is:&nbsp;

If([Supplier] = "Workday", true, [Supplier] = "Amadeus", true, [Supplier] = "Flightkeys", true, [Supplier] = "Google", true, false)

------------------------------Personal Tax Team------------------------------

chayceduncan · Answer

Your first formula with the [Supplier]="" OR syntax looks fine. Do you have an example where it's not responding as intended? Double check that your supplier entries match exactly what is in your data, QB is case sensitive so if you anticipate that being an issue you can always do Lower([Supplier]) = "workday" as an example

------------------------------
Chayce Duncan
------------------------------

Forum Discussion

IF OR Statement Errors

2 Replies