Formula to calculate how many circles fit in a larger circle

[ioncila]

Hi
To calculate this, I'm using a simple formula that divides the area of the larger circle by the area of the smaller.
For example, if I want to know how many Ø63 circles fit in a Ø250 circle, I do this:
=INT((125^2*PI())/((32.5^2*PI()) to result = 14

But I think this is a wrong approach.

May someone clarify me about this, please?

Thank you very much

ioncila

[SamT]

you can get a closer "ballpark" figure by squaring off the smaller circle (D^2)
=INT((125^2*PI())/((2*32.5)^2))

[ioncila]

I have edited my last post because formula was not correct. But I guess you understood

you can get a closer "ballpark" figure by squaring off the smaller circle (D^2)
=INT((125^2*PI())/((2*32.5)^2))

I have tried that before but not the way you are showing
With a little help of geometry drawings I verified that you are right.

Thank you very much
It was a great help