Dec 08 2022 06:03 AM
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"),"",))
Dec 08 2022 06:10 AM
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