best formula to use

[raw]

Hi

What would be the best formula to use if i want to find out how much a number would go into a number then the left over part

Eg

Q. 2000mm is the size and need to know how many times 76.2mm goes into it

A. 26times which then leaves 18.8mm over

Thank you

[Peo Sjoblom]

With 2000 in A1 and 76.2 in B1

=INT(A1/B1)

will return 26

the rest

=MOD(A1,B1)

--
Regards,

Peo Sjoblom

(No private emails please)


"raw" <[email protected]> wrote in message
news:[email protected]...
>
> Hi*
>
> What would be the best formula to use if i want to find out how much a
> number would go into a number then the left over part
>
> Eg
>
> Q. 2000mm is the size and need to know how many times 76.2mm goes into
> it
>
> A. 26times which then leaves 18.8mm over
>
> Thank you*
>
>
> --
> raw
> ------------------------------------------------------------------------
> raw's Profile:
> http://www.excelforum.com/member.php...o&userid=28312
> View this thread: http://www.excelforum.com/showthread...hreadid=488052
>

[Gord Dibben]

I think you would need two formulas but maybe someone else will get clever.

=ROUND(2000/76.2,0) reurns 26

=2000-76.2*ROUND(2000/76.2,0) returns 18.8


Gord Dibben Excel MVP


On Thu, 24 Nov 2005 17:59:02 -0600, raw
<[email protected]> wrote:

>
>Hi*
>
>What would be the best formula to use if i want to find out how much a
>number would go into a number then the left over part
>
>Eg
>
>Q. 2000mm is the size and need to know how many times 76.2mm goes into
>it
>
>A. 26times which then leaves 18.8mm over
>
>Thank you*