Calculate the number of machines required

[lre712]

Hello all,

I am trying to write a formula to calculate the number of machines required for production.

Each machine has a maximum output of 100,000 units.

100,000 units = 1 machine
100,250 units = 2 machines
200,000 units = 2 machines
200,030 units = 3 machines and so on.

I have attached the file for reference.

I need cells C16, F16, I16 to update based on the demand value in Cells C12, F12, I12.

I have tried [=IF(C12<=C12,1,IF(C12>C12+1,1))] but am stuck, I know the second part of the formula is incorrect. I think I need to write something like IF C12>C12+1 but is less than....

I hope this makes sense. Sorry for if i am not clear enough.

Cheers
Lee

 

[vletm]

lre712
for cell C16 =ROUNDUP(C12/$B4,0)
and copy&paste to needed cells

 

[lre712]

Thanks for the quick response @vletm