Help calculating number of runs based on number of items to be run

[Brent_bousquet]

I need help finding out the number of times I need to run a furnace based on the number of items that need to go in it. The max number of items per run is 6 so if there's 6 it's 1 run. If there's 7 it will be two runs. 9 is still two runs but 13 is 3 runs and so on up to infinity. I can't for the life of me figure out how to do that and I can't figure out the right terms to search for to find it online.

[#2 · Accepted solution]

Hello @Brent_bousquet,

Here is a possible solution:

=ROUNDUP(A1/6,)

[#3]

Thanks that works perfectly for what I need

[#4]

@Brent_bousquet 

My pleasure!