Hi guys
I am trying to write simple algorithms in Excel and for one function I have difficulties.
What I want to do is that if the difference between a row of two columns is positive write "A" and if the next row is positive it would be blank instead "A" and also for negative values. if the difference between a row of two columns is negative write "B" and if the next row is negative also it would be blank instead "B".
=IF((AND(A2>B2, A1>B1)), "", "B"), IF((AND(A2<B2,A1<B1)),"","A")
this is I wrote but it does not work.
Bookmarks