Hi and welcome
This seems to work =CEILING(I9,FLOOR(I9/50,1)+(0.25*(I9<50))+5*(I9>=1000))
(replace I9 with your cell ref)
In the future please add a small sample sheet ( no pics please) with desired results and some data
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|