Ask Your Question
0

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

asked 2019-08-10 16:21:34 +0200

0for4 gravatar image

updated 2019-08-10 16:56:45 +0200

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&lt;/p">

edit retag flag offensive close merge delete

Comments

Please don't forget to format your formatted data as such, using dedicated toolbar button "preformatted text".

Mike Kaganski gravatar imageMike Kaganski ( 2019-08-10 16:58:24 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2019-08-10 16:51:59 +0200

Opaque gravatar image

Hello

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

edit flag offensive delete link more

Comments

... and again, the case when A1 is between A2 and A2+1 is undefined :-)

Mike Kaganski gravatar imageMike Kaganski ( 2019-08-10 16:56:49 +0200 )edit

Thank you You are the best

0for4 gravatar image0for4 ( 2019-08-10 16:58:32 +0200 )edit

... if not restricted to the set of integers :-)

Opaque gravatar imageOpaque ( 2019-08-10 17:33:23 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-08-10 16:21:34 +0200

Seen: 27 times

Last updated: Aug 10