Forum Discussion
IF Function
Shouldn't there be a way to look at a column of values and be able to say, if 1 then 30, if 2 then 27, if 3 then 24, if 4 then 21, etc?
=SEQUENCE(30,,30,-3) counts down by 3.
I am assuming the adjacent column is already sorted in rank order...so there's no need then to look at it.
- Perhaps I misinterpreted the OP's requirements.
Big_Event mathetes formula will put values in a range, where as mine is assuming you have that in place and want to enter a number to return said placed values by rank. Rather than continue with two disparate solutions, it would help if you could qualify your needs exactly.Good point, Zack. I took these words from the very first posting--"I'm trying to assign a number value to a previously assigned rank".--to mean that that previous set of data had already been ranked.
But then in my first response, I missed the stepping down by intervals of 3--"For instance, ranking #1 receives a value of 30, ranking #2 receives a value of 27, ranking #3 receives a value of 24, etc."
"I can't imagine this being difficult but I just don't know how to write this formula." and SEQUENCE being a relatively new Function, although it's easy, it's not all that well known.
- That's what I posted... ?
