Complex IF formula.

Hi everyone. Take a quick look at this from my first thread:

Excel 2010
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
2 54 43 29 35 40 56 53 65 71 75 45 28 35 51 60 71 72 52 49 48 29 25 28 35 51
3 0 0 1 1 1 0 0 0 -1 -1 0 1 1 0 0 -1 -1 -1 0 0 1 1 1 1 0


Worksheet Formulas
Cell Formula
B3 =IF(OR(AND(B2>=30,B2<50,A3=1),B2<=30),1,IF(OR(AND(B2>=70,B2<100),AND(B2>=50,A3=-1)),-1,0))
---------------------------------------------------------------------------------------------------------------------------------------------------------------

Problem

Can you maybe help med to change this formula? It's the same rules and structure. However, I want the signals (-1,1,0) to be given the day after and not the same day as above.
So with kind of a lag. (See excel sheet for example of how it should be. Here you also find the formula). I guess it should be possible to make a little change of the formula?

So at the day it gives over/under 70/30 it should just be 0, and the signal should come the day after. Thanks!!! :D :D