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:and if you need it to never be below 400 you could use:![]()
=MROUND(A2,200)
![]()
=MAX(MROUND(A2,200),400)
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:and if you need it to never be below 400 you could use:![]()
=MROUND(A2,200)
![]()
=MAX(MROUND(A2,200),400)
-GregIf this is helpful, pls click Star icon in lower left corner
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks