View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
shak shak is offline
external usenet poster
 
Posts: 2
Default working with rations in Excel

I have two figures one representing the number of employees in a
company and the other the number of shared cars. I want to find the
ration of employee to cars such as 1:4 and then have an optimal ratio
such as 1:2, calculate the difference between optimum ratio and actual
ratio and then in another cell display the number of cars to add to
fleet to arrive at the optimum ratio. How would you do that?

Any help would be appreciated.
Shak