Apr 10 2021 05:50 PM
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
Apr 10 2021 06:42 PM
@scott4855
That could be:
=LOOKUP(B5,{-3;-2;-1;0;1;2},{8;6;4;2;1;0})