Excel formula help

[electrichi01]

Hi folks

Looking for some help. Trying to return a value to a cell like such:

Cell A1- has a number- lets say 10
Cell A2- has a number- lets say 15
Cell B1- has a number- lets say 20
Cell C1- this is where I want to solve for the formula

Want to divide the B1 into A rows to come up with a number. We know 20 goes into 10- 2 times, so the answer would be 2. 15 goes into 20, 1.5 times.

What I want to achieve is the following:

1. When the A1 or A2 has a number that is = to or less than, I want to return 1 in cell C1. When A1 or A2 has a number that is larger than B1, I want to divide the number and if it is more than 1 (B1/A2), I want to round up to 2.

If B1 is 30, then I'd want to do the same thing- so, A1 would solve for 3 and so would A2 (even though its 2.5), and want to round up.

Thank you!

 

[Scott Huish]

I don't understand your second example.

If B1 was 30

C1 would be equal to 3 (30/10) and C2 would be equal to 2 (30/15). Where does the 2.5 come in?

 

[electrichi01]

Hi

B1 is going to be a dynamic cell that is always changing from another sheet that will trigger a change in the equation/division and rounding up.

What I'm driving at is the dynamic #, Cell B1, is going to be the determining factor as it is locked (F4) as an absolute reference to Row A (A1, A2 etc). So I want to return a rounded up number.

So, if A1 had 10 and B1, had 1-10, I want a 1 in cell C1. If A1 had 10 and B1 had 11, I want a 2 in C1. If A1 had 10 and B1 had 21, I want 3 in C1.

Make sense?

Thank you.

 

[Scott Huish]

=if(a1,-int(-b1/a1),"")

 

[electrichi01]

Thank you , Thank you, Thank you!

That did it Hot Pepper!