S
Simon Lloyd
Hi all,
Im trying to get a cell to display either 1, 0 or -1 depending on other
cells product here's what i'm using
=IF(E5=0,0,IF(OR(B$5-E5<0,B$5-E5>4),0,VLOOKUP(B$5-E5,{-1,1;-2,1;-3,1;1,-1;2,-1;3,-1},2)))
i can get itto display 0 or -1 or 0 and 1, my criteria is this if E5 >
B5 by any amount then display -1 if E5 = B5 then display 0 and if E5<B5
by any amount display 1.
I cant seem to manage it with the formula above, any ideas?
Regards,
Simon
Im trying to get a cell to display either 1, 0 or -1 depending on other
cells product here's what i'm using
=IF(E5=0,0,IF(OR(B$5-E5<0,B$5-E5>4),0,VLOOKUP(B$5-E5,{-1,1;-2,1;-3,1;1,-1;2,-1;3,-1},2)))
i can get itto display 0 or -1 or 0 and 1, my criteria is this if E5 >
B5 by any amount then display -1 if E5 = B5 then display 0 and if E5<B5
by any amount display 1.
I cant seem to manage it with the formula above, any ideas?
Regards,
Simon