I have data set that looks like this:
A | B
-------
a 1
b 2
c 3
d 4
e 5
f 6
I would like create a column C that based on threshold of column B, in our case 4, returns a value from column A plus above or underneath.
A | B | C
----------
a 1 a above
b 2 b above
c 3 c above
d 4 d underneath
e 5 e underneath
f 6 f underneath
I don't even know where to start, so please help without downwoating my post.
