Hello.

Is there a way (formula) to output a value for a boolean?

Say I wanted to show a "1" in a column for C > C1 when true. Is there a way to trick v17 into doing something like this? And if so, could it sum multiple values in a single formula where true? E.g.
C > C1 (1) +
C > C1 () +
C > C3 (1) +
__
2

Thank you.

Sorry, that should read:
C > C1 (1) +
C > C2 () +
C > C3 (1) +
__
2

IIF(C > C1, 1, 0) + IIF(C > C2, 1, 0) + IIF(C > C3, 1, 0)

Or the slightly shorter

-(C > C1) - (C > C2) - (C > C3)

Inline IF and converting conditions to indicators

Thank you, Bruce. A next step question:

Is it similarly possible to output values for tiered timeframes in one formula?

Say I want to do:

C > XAVGC8 (D)+
C > XAVGC8 (4 HR)+
C > XAVGC8 (2 HR)+
C > XAVGC8 (1 HR)+
C > XAVGC8 (30M)+
C > XAVGC8 (15M)+
C > XAVGC8 (10M)+
C > XAVGC8 (5M)+
C > XAVGC8 (1M)

No, it is not.

Thank you, Bruce.

You're welcome.