Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
best formula to use
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
best formula to use
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
best formula to use
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 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* |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula? | Excel Worksheet Functions | |||
Formula works in some cells, doesn't in other | New Users to Excel | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |