Forum Discussion

erin-5304's avatar
erin-5304
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 tried to start this but was lost with how to continue....

=IF(DataEntry!O64="Accept",("X"),"")

Formula 2:

If both DataEntry!O66 or DataEntry!O67 equals "Decline" then C27 will have an "X" , if either cell has "accept" it is left blank.

Here is what i have for this one so far...

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

 

Formulas and Functions
  • Zach Prins's avatar
    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

Resources