And/Or Formulas

Kelly R.

Hi All,

Need help with an IF statement using AND/ OR. I need to be able to check the box whether the vendor change/disc change/vendor catalog columns are blank or some of them have a value (ex: Vendor Change) in it and I keep getting an error.

Here is my formula, any suggestions.

=IF(AND([Vendor Change]@row = "Vendor Change", [DISC CHANGE]@row = "Discontinuation", [Vendor Catalog]@row = "Vendor Catalog"), 1, IF(OR([Vendor Change]@row, "", [DISC CHANGE]@row, "", [Vendor Catalog]@row, ""), 1, 0)))

Thanks,

Kelly

Paul Newcome

This will check if at least one is not blank.

=IF(OR([Vendor Change]@row <> "", [DISC CHANGE]@row <> "", [Vendor Catalog]@row <> ""), 1)

Paul Newcome

I'm not sure I follow exactly what you are wanting to accomplish. Will it always be those text strings in those columns? Does it matter what text is in them or just blank vs not blank? Your existing formula is checking the box if none are blank or all are blank but not for any combination. Is that accurate?

Kelly R.

Hi Paul,

Yes those are always the text strings. I would like the box to check when there is any of those text strings in the columns. If two of the columns have the text strings and third column is blank, the box should check. If the columns have no text strings then there would be no check box. Does that make more sense.

Paul Newcome

This will check if at least one is not blank.

=IF(OR([Vendor Change]@row <> "", [DISC CHANGE]@row <> "", [Vendor Catalog]@row <> ""), 1)

Kelly R.

Thanks Paul that did work. Appreciate your help!

Paul Newcome

Happy to help. 👍️