can't get the A1>A2 by more then 1 to equal=0

0for4 · August 10, 2019, 2:21pm

here’s what I need

A1>A2 by more then 1 to equal =0
A1>A2 by 1 to equal =1
A1=A2 to equal=2
A1<A2 to equal =3

mikekaganski · August 10, 2019, 2:58pm

Please don’t forget to format your formatted data as such, using dedicated toolbar button “preformatted text”.

anon73440385 · August 10, 2019, 2:51pm

Hello

=IFS(A1>(A2+1),0,A1=(A2+1),1,A1=A2,2,A1<A2,3)

mikekaganski · August 10, 2019, 2:56pm

… and again, the case when A1 is between A2 and A2+1 is undefined

0for4 · August 10, 2019, 2:58pm

Thank you You are the best

anon73440385 · August 10, 2019, 3:33pm

… if not restricted to the set of integers