Multiplication of two cells and compare to a third, then auto increment a fourth

New to the forum and would appreciate any help that can be offered.

I am trying to figure out a formula for the following:

Final implementation is more but in essence, I am trying to achieve the following:

I have four columns. I would like to multiply the values in column A & B and take the result and compare it to column C. If less than or equal to the value in Column C then increment by 1 the value of Column D until the result of A & B is greater than column C.

So if column A is 2 and column B is 100 and column C is 1000, column D would calculate it takes 6 times for 2*100 to be greater than Column C @ 1000.

I was trying to do this with a single function in Column D but..... any advice would be greatly appreciated.

William

Or try this ...

=A2*B2*(ROUNDDOWN(C2/B2/A2,0)+1)

Thank you both. Both of the formula's are giving me the same incorrect result.

Based on the example above: If column A is 2 and column B is 100, and column C is 1000. How many times do I have to multiply column A and B to be greater than column C. The answer I am looking for is 6, but the results for both formulas is giving me 1,200.

((A*B)*column D) > C. So the I would have to multiply 2 x 100, 6 times to be greater than 1000. That is what I am trying to do.

Thanks all for your help.

William

Try

=(ROUNDDOWN(C2/B2/A2,0)+1)

Cannot believe it was that simple. Thank you!