Forum Discussion

Brass Contributor

Dec 08, 2022

Multiple If Formula

Need help with a couple formulas for the following..... Formula 1: If either DataEntry!O66 or DataEntry!O67 equals "Accept" then C25 will have an "X", if neither have "accept", it is left blank. I...

Formulas and Functions

Zach Prins

Brass Contributor

Dec 08, 2022

Hi erin-5304,

For "either" we use the OR operator, for "both" we use the AND operator.

Formula 1:

=IF(OR(DataEntry!O66="Accept",DataEntry!O67="Accept"),"X","")

Formula 2:

=IF(AND(DataEntry!O66="Accept",DataEntry!O67="Decline"),"X","")

Regards,

Zach