Forum Discussion
Jammor
Jun 20, 2020Copper Contributor
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...
- Jun 21, 2020
PeterBartholomew1
Jun 20, 2020Silver Contributor
= IF(number#<4, 5, 8-number#)
Jammor
Jun 21, 2020Copper Contributor
PeterBartholomew1 Yes, this worked great. Thank you.