using boolean in excel 2007

[bored]

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!

[shg]

Welcome to the forum.

=if(a1 > 20, myFunction(A1), na())

[bored]

thanks, it solved my problem!