Hi,
If i have a column of numbers, can i pick up the number that falls within a certain range? For example, i want the number that is between 10000 and 20000, is that any formula or function i can use to pick up that number? Appreciate if somebody can help me. thxs.
Hi,
Not sure what you mean by "pick up". Assuming your data column is column A. And your first number you want to evaluate is in cell A2. Put this formula is a blank column.
IF((AND(A2>10000,A2<20000)),"YES","NO")
This formula will put Yes in the column if it meets the criteria and no if it does not.
HTH
Casey
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks