79244305

Date: 2024-12-02 13:45:02
Score: 1
Natty:
Report link

You can use Sign() with the (Condition)+(Condition) to Cleanly cap at 1.

So for your example:

SIGN( (A1:A3 > 0) + (B1:B3 > 0) )

SIGN Array OR Example

Reasons:
  • Whitelisted phrase (-1.5): You can use
  • Low length (1):
  • No code block (0.5):
  • Low reputation (1):
Posted by: Seth Kirk