neested

[pytelium]

I have a column of numbers a1 to a6

3.5
3.5
3.6
3.7
4.3
2.1

I want create another column b1 to b6 which prints INif a2<a1,prints
OUT if a2>a1 and prints SAME if the 2 values are the same.The formula
must compare each cell to the cell above it.I think its nested IF but
cant get it right.

 

[Bill Kuunders]

=IF(A2<A1,"IN",IF(A2>A1,"OUT","SAME"))
extend down the column

 

[pytelium]

Thank you,Bill

Greetings from Ireland

Michael