Round a Column of Numbers to a Specific List

Originally Posted by gjlindn

Could you use the MROUND function? It looks like your list is incremented by 200. So if your data is in column A it would be:

=MROUND(A2,200)

and if you need it to never be below 400 you could use:

=MAX(MROUND(A2,200),400)

Is a2 only going to round column a row 2 or does that do the entire column? I guess ill go try this (Im on my android right now). Ill get back to you soon and give you some positive feedback if it works!