Translating multi-row Excel formula

[carterfleming]

How would I write the following formula in Alteryx? Note that this formula is looking at two different rows:

I also need the inverse formula, i.e. using the next row instead of the previous:

[ShankerV · Accepted solution]

Hi @carterfleming 

One way of doing this.

[RobertOdera]

Hi, @carterfleming 

Please create samples for your input and your desired output.

1. Most multirow formulas will depend on treatments on the first row of data (and/or critical columns if leveraging group by) as a basis for what follows next for logical output

2. Most inverse arguments can be achieved by inverting the sort order of key columns or deploying counterclockwise logic (e.g., instead of = use != or instead of using the previous row, use the next row...to determine the current row value)

At any rate, kindly consider providing samples for better context, and the community will help you (much easier). Cheers!