best formula to use

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

raw - 24 Nov 2005 23:59 GMT

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*

Signature

raw

Reply to this Message

Peo Sjoblom - 25 Nov 2005 00:14 GMT

With 2000 in A1 and 76.2 in B1

=INT(A1/B1)

will return 26

the rest

=MOD(A1,B1)

Signature

Regards,

Peo Sjoblom

(No private emails please)

> Hi*
>
[quoted text clipped - 9 lines]
>
> Thank you*

Reply to this Message

Gord Dibben - 25 Nov 2005 00:50 GMT

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

>Hi*
>
[quoted text clipped - 9 lines]
>
>Thank you*

Reply to this Message