Thread: Ratio Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Samantha0310 Samantha0310 is offline
external usenet poster
 
Posts: 1
Default Ratio Function

Hello.
Ok, I am looking to have a ratio that pretty much describes how many office
personnel there are to how many shop employees there are.

So in my worksheet, I want the ratio to show up as - 1:3.35

Here is my information:

In E24 I have 67 (shop employees) and in E39 I have 20 (office employees).
What is the formula I would use?

Thank you so much!