formula

[scott4855]

need formula for 

b2-b3=

if greater than 1 return 0

if = to 1 return 1

if = to o return 2

if = to -1 return 4

if = to -2 return 6

if = to -3 return 8

[#2]

@scott4855 

That could be:

=LOOKUP(B5,{-3;-2;-1;0;1;2},{8;6;4;2;1;0})