hi,
say i have a column of 1,000 numbers (for instance in column A), and i want to pick out those that are >20. what i am thinking of is, in the corresponding cell in column B, i want to do something as follows:
if (number > 20), carry out a function on it
else, print "NA"
hope i am right in classifying this problem as a boolean issue...
thanks for reading!
Bookmarks