look for value in columns

[keis386]

Dear sir/madam,

I have a short question.

If there is a number in cell G4, note in cell b4 a 0 if the following number in collumn G is higher then a 1. If the following number is a 1 note a 1

I attached a excel file. In collumn D you can check if the answers are right

[Dionysos]

Enter in B3:
=IF(G3="","",IF(G3=1,1,IF(G3>1,0)))