Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
I'm trying to get a ratio between 2 numbers, that's if I'm asking for the
correct formula. I was sent the dashboard and example the numbers they gave me is as follows: 243/174 would = 1 to 40..... Can someone help me with this formula. I thought it would be easier to put a formula in rather then having this person figure it out the long way. -- Thanks, Mary |
#2
![]()
Posted to microsoft.public.excel.setup
|
|||
|
|||
![]()
Hi Mary,
Your post is a bit confusing, I don't know where the 1 to 40 comes in. With a little bit of rounding 243 is 140% of 174, which could be expressed as 140 to 100. Please explain further what you have and what you are trying to do. HTH Martin "Mary" wrote in message ... I'm trying to get a ratio between 2 numbers, that's if I'm asking for the correct formula. I was sent the dashboard and example the numbers they gave me is as follows: 243/174 would = 1 to 40..... Can someone help me with this formula. I thought it would be easier to put a formula in rather then having this person figure it out the long way. -- Thanks, Mary |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Ratio | Excel Discussion (Misc queries) | |||
Divide x/y should give Ratio x:y,How to express ratio in excel | Excel Worksheet Functions | |||
How do I express a ratio? | Excel Discussion (Misc queries) | |||
Want to display ratio | Excel Discussion (Misc queries) | |||
Ratio function | Excel Worksheet Functions |