Add XOR formula

0 Kudos

Add XOR formula

Title says it all, a XOR formula would be really helpful and reduce formula length when trying to test an exclusive or.

 

For those unfamiliar, here is the logic table for XOR. It acts as an OR however if both inputs are TRUE, then XOR returns false.

XOR.png

2 Comments
Community Manager
 
Status changed to: Your support is needed
Master Anaplanner/Community Boss

@Nicolas Cadier 

One use case I can think of that might take advantage of this is when I need to make sure I have one, and only one, TRUE. I do this all the time for validation work. Would you envision this working across a list? Meaning it tests all the list items and only returns a TRUE if only one of the conditions is TRUE?

Users Online
Currently online: 217 members 724 guests
Please welcome our newest community members: