Multiple If Formula

Contributor

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"),"",))

 

1 Reply

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