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!

Ratio Function
 

Samantha,

="1:"&TEXT(E24/E39,"0.00")

HTH,
Bernie
MS Excel MVP


"Samantha0310" wrote in message
...
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!

Ratio Function
 

Try this:

="1:"&ROUND(E24/E39,2)

Note that this results in a TEXT string.

--
Biff
Microsoft Excel MVP


"Samantha0310" wrote in message
...
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!