+1 until -1

Example data please

"if A is above B by 2"

Badly worded, but I'm taking this to be IF(A1=B1+2...

"if A is below 2"

Based on the above I think you mean IF(B1=A1+2...

Try this

Start your data in row 2, NOT row 1

in C2
=IF(A2=B2+2,1,IF(B2=A2+2,-1,C1))
and copy down

If this doesn't give you what you want then supply some example data with expected output. Check your output before posting.

	a	b	c	d
1
2	1	5	-1	c2: =if(a2 >= b2+2, 1, if(a2 <= b2-2, -1, c1))
3	5	6	-1
4	2	3	-1
5	2	5	-1
6	2	4	-1
7	6	2	1
8	2	2	1
9	3	2	1
10	6	2	1
11	1	4	-1
12	1	4	-1
13	3	6	-1
14	2	2	-1
15	2	4	-1
16	5	2	1
17	4	1	1

Hi

I have attached a sheet, the data is updated real time in the two variables, dont know if its possible without a macro or not as the example above assumes there is rows of data nd in my sheet there is not.

There is just to two cells with changing data.

May be this

=IF(A4>A3-1,-1,1)