Multi Row Formula Tool Calculations

[dassyia]

All,

Ref	Amt
210-10	5000
EST
210-05	-200
PY-M1	200

I am trying to calc the missing number in the Amt column that corresponds to the EST in the Ref column.  The calc would be EST = (210-05/PY-M1) * 210-10 so (-200/200)*5000

So in the configuration pane of the multi row formula tool. I set Num Rows to 2. then enter  IF [Ref] = "est" THEN [AMT] = ([Row-2:AMT]/[Row-1:AMT])*[Row+1:AMT] ELSE [AMT] ENDIF 

The output shows zero instead of -5000. 

Any help would be greatly appreciated. 

[Philip · Accepted solution]

I'm going to make the assumption that the rows are always in the correct order. It looks like you got your +/- rows backwards. If you still get a 0, then make sure you are using literal match of "EST".

[dassyia]

Thanks! Your formula worked!