| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
divide a resultant number into another number
I need to divide two numbers and then divide the result of that calculation
into 365. This is for stock turn purposes ie Total Number of Days in Stock divided by Total Number of Units, reult is then divided into 365 Example: b16/d17 = 57, how do I then divide 57 into 365? Many thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
divide a resultant number into another number
Try this
=365/($B$16/$D$17) But because I'm not sure what you mean maybe this =($B$16/$D$17)/365 Mike "DavidR" wrote: I need to divide two numbers and then divide the result of that calculation into 365. This is for stock turn purposes ie Total Number of Days in Stock divided by Total Number of Units, reult is then divided into 365 Example: b16/d17 = 57, how do I then divide 57 into 365? Many thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
divide a resultant number into another number
try
=365/(B16/D17) "DavidR" wrote: I need to divide two numbers and then divide the result of that calculation into 365. This is for stock turn purposes ie Total Number of Days in Stock divided by Total Number of Units, reult is then divided into 365 Example: b16/d17 = 57, how do I then divide 57 into 365? Many thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
divide a resultant number into another number
Perhaps...
=(b16/d17)/365 -- HTH... Jim Thomlinson "DavidR" wrote: I need to divide two numbers and then divide the result of that calculation into 365. This is for stock turn purposes ie Total Number of Days in Stock divided by Total Number of Units, reult is then divided into 365 Example: b16/d17 = 57, how do I then divide 57 into 365? Many thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
divide a resultant number into another number
For what you have described, you want this...
=365/(B16/D17) Rick "DavidR" wrote in message ... I need to divide two numbers and then divide the result of that calculation into 365. This is for stock turn purposes ie Total Number of Days in Stock divided by Total Number of Units, reult is then divided into 365 Example: b16/d17 = 57, how do I then divide 57 into 365? Many thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
divide a resultant number into another number
Very many thanks; that worked for me.
DavidR "JMB" wrote: try =365/(B16/D17) "DavidR" wrote: I need to divide two numbers and then divide the result of that calculation into 365. This is for stock turn purposes ie Total Number of Days in Stock divided by Total Number of Units, reult is then divided into 365 Example: b16/d17 = 57, how do I then divide 57 into 365? Many thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I divide one number into another number using excel? | Excel Worksheet Functions | |||
| How to divide a number into various denominators | Excel Worksheet Functions | |||
| Function 2 divide a number (ie $1.00) by % (ie 25%) to = ($4.00)? | Excel Worksheet Functions | |||
| How do I divide a number by another number when there is no divis. | New Users to Excel | |||
| Divide one row over other row I dont wont to divide one number | Excel Discussion (Misc queries) | |||
Linear Mode
