P
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.
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.