=IF(OR(A2<12000,A2>=60000)
I'm intending on copying the formula down for all values in column 2The current formula refers to column A which is column 1. Can you clarify what you are planning to do for other values? If it should be column 2 or B, then simply change the formula to:
Title | # Comments | Views | Activity |
---|---|---|---|
Query output to Excel producing error | 7 | 27 | |
Merging multiple rows to one | 22 | 32 | |
Excel: Comparing the Values in One Column with the Values in Another | 2 | 22 | |
Excel Array formula issues | 4 | 7 |
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
6 Experts available now in Live!