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" wrote in message
...
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