Hello,
I need to do this:
If the value for a cell in each row is less than the mid-point value for the row and column, display -1
If the value for a cell in each row is greater than the mid-point value for the row and column display 1, otherwise display 0


It needs to account for a value in both the same row and column. I tried this: =IF(AND(A1<A$24,A1<$W1),AA3,IF(AND(A1>A$24,A1>$W1),$AA$2,$AA$4)) but all I got where 1's


Can anyone help?