JammorCopper ContributorJun 20, 2020SolvedFormula 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...Show MoreSergeiBaklanJun 21, 2020Jammor As variant =MIN(5,8-A1)
BennadeauIron ContributorJun 21, 2020Hi Jammor,This should do the trick...=IF(OR(A1=1,A1=2,A1=3),5,IF(A1=4,4,IF(A1=5,3,IF(A1=6,2,IF(A1=7,1,0)))))You can replace the last 0 with whatever you want to be displayed should the value in column A be outside the range you defined.
