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

--
Greetings from New Zealand
Bill K
"pytelium" <pytelium.1tq3qa_1123970705.5374@excelforum-nospam.com> wrote in
message news:pytelium.1tq3qa_1123970705.5374@excelforum-nospam.com...
>
> 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.
>
>
> --
> pytelium
> ------------------------------------------------------------------------
> pytelium's Profile:
> http://www.excelforum.com/member.php...o&userid=25521
> View this thread: http://www.excelforum.com/showthread...hreadid=395595
>

[pytelium]

Thank you,Bill

Greetings from Ireland

Michael