Forum Discussion

Copper Contributor

Jun 20, 2020

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...

excel

SergeiBaklan
Jun 21, 2020
Jammor

As variant

=MIN(5,8-A1)

PeterBartholomew1

Silver Contributor

Jun 20, 2020

Jammor

= IF(number#<4, 5, 8-number#)

DevendraJain

Iron Contributor

Jun 21, 2020

Is the issue solved

PeterBartholomew1
Silver Contributor
Jun 21, 2020
DevendraJain
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!)