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.

Comments

Miran

Status changed to: New

JaredDolich

@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?

jlittleh

Note XOR gate definition produces a 1 logic output for an input of an ODD number of logic 1s, hence it will be Exclusive for two arguments only.

If you'd like an Exclusive function or operator over a list of arguments, (only one TRUE argument produces a TRUE output) then you may use 1=(the count or sum of the 1s).

Quick Links

New ideas

AXL maximum cellset size increase
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: For data that has multiple dimensions, users need to be able to extend a Grid to its lowest intersections. Often the Grid cellset is…
Formatting breaks when copy/pasting text into a new Text Card
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: When copying text from an existing Text Card on a published page and pasting it into a new Text Card in edit mode, the rich-text…
I would like to see more undo returns on UX pages.
I would like to see more undo returns on UX pages. It takes a lot of time to check before entering precise information in a cell or in a series of cells.