Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can Excel display the ratio of two numbers?
I am comparing 2008 Sales data to 2009 Sales data. Ideally, I would like to
display the ratio of clients month-to-month, preferably in a pivot table and/or pivot chart. E.g., Jan '08 has 7 clients. Jan '09 has 21 clients. The ratio displayed is 1:3. Does anyone know if this is possible in Excel? If so, what is the function? Thank you! p.s. -I am using Excel 2007. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can Excel display the ratio of two numbers?
=A2/GCD(A2,B2)&":"&B2/GCD(A2,B2)
"GERALDRT" wrote: I am comparing 2008 Sales data to 2009 Sales data. Ideally, I would like to display the ratio of clients month-to-month, preferably in a pivot table and/or pivot chart. E.g., Jan '08 has 7 clients. Jan '09 has 21 clients. The ratio displayed is 1:3. Does anyone know if this is possible in Excel? If so, what is the function? Thank you! p.s. -I am using Excel 2007. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for category ratio & numbers | Excel Discussion (Misc queries) | |||
Divide x/y should give Ratio x:y,How to express ratio in excel | Excel Worksheet Functions | |||
Want to display ratio | Excel Discussion (Misc queries) | |||
How can I display a number as a ratio of x:1 in Excel? | Excel Worksheet Functions | |||
How do I calculate and display ratio ( format 3.5:2) | Excel Worksheet Functions |