Excel Formula Question
Posted on 2011-02-23
I've been trying to figure this out on my own for a week. Formulas just aren't my strong suit.
I have a column of data in A. From A1 to A200 let's say. I want a formula that will test each value in column A and assign it a different value in B. For example, if A1 is between 1 and 11, I would like a value in B1 of -1 and I want to carry this on all the way down the line.
The range values I am look at are:
Arcane Excel Wizards, I call upon your dark powers to aid me....