Suppose there are some random numbers for example 4,7,9,3,13,6. if its 4 then it should display 6, if its 7 then it should display 9, if its 9 then it should display 9. Now you may have understood what i am looking for. I hope i receive some help. Thank You for trying

Are you in Excel? =3*(ROUNDUP(A1/3,0))

where A1 is the cell the random number is in.

Ask Your Question

Weekly Poll