Forum Discussion
Solved
Formula help
I have a column of numbers. There are >200 rows, with each cell in the column having one number between 1 and 10. In the column next to it, I want to copy down a formula that outputs a different nu...
= IF(number#<4, 5, 8-number#)
PeterBartholomew1 Yes, this worked great. Thank you.
- Is the issue solved
It worked on my machine but I forgot to explain that "number#" was a dynamic range generated by the RANDARRAY function. That is the way I reference data, but any other form of reference to a whole number can be used (even the practice of direct cell references such as B27 if you must!)
