Continuous/endless IF pattern

I am having trouble figuring out the IF formula for when a cell number that the user inputs increases by 1000 another cell increases by 1.

For example if 8000m of rock is mined then 8 tests must be done.
78000m produced 78 tests must be done.

I know I can extend a formula for every increase in 1000 but as the initial number may be as high as 120000 I’d prefer not to haha. Is there some sort continuous pattern formula I can use so that if we produce 50000m of rock it tells the user 50 tests must be done??
By: Campbell

Leave a Reply

Your email address will not be published. Required fields are marked *