divide a resultant number into another number

D

DavidR

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
 
M

Mike H

Try this

=365/($B$16/$D$17)

But because I'm not sure what you mean maybe this

=($B$16/$D$17)/365

Mike
 
R

Rick Rothstein \(MVP - VB\)

For what you have described, you want this...

=365/(B16/D17)

Rick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Divide a number into multiple cells 2
dividing a number up evenly into a year 3
Divide variable numbers into groups 2
divide a month's target into weeks 4
dividing a number into hours and minutes 1
forecast a financial value at year end 1
Divide number and add remainder in another cell 4
Working With Dates in Excel 2

Top