I’m wondering if it’s possible to emulate a logical OR gate in Calc, with inputs from more than one cell determining the output of another. For instance, if I had two cells called A and B, and either value was greater than zero, cell X would display unity as an output. If both A and B were zero, X would be zero. I’ve tried various combinations of IF, OR, AND and IFS but with no success. I just need to know if it can be done, and if so, what’s the syntax for the formula? Thanks!
Nothing needing to be emulated. The OR() function is the equivalent of an OR-gate represeneted the functional way. . The argument positions are the input connections, the cell containing the formula is the output.
You surely also know that any number is accepted in Calc as a representation of a Boolean value: <>0 is taken for True, =0 for False.
disask101319_OR_gate.ods (16.5 KB)
Thanks for that! I thought the assumption that I ‘surely know’ was a little condescending, considering that I have only a passing aquaintance with logic gates acquired over 40 years and largely forgotten. But as I’m relatively new to anything more involved than simple arithmetic functions within the program, I’ll forgive you this time.