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.

Or

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