Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel
how do i form a ratio. is there a formula?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel
Would this do? In C1 type:
=A1/B1 For a ratio of the content of the A1 cell over the B1 cell. Is that what you are looking for? Miguel. "Jeanie" wrote: how do i form a ratio. is there a formula? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel
Make sure you have the Anaysis Toolpak Add-in installed
=A1/GCD(A1,B1)&":"&B1/GCD(A1,B1) "Miguel Zapico" wrote: Would this do? In C1 type: =A1/B1 For a ratio of the content of the A1 cell over the B1 cell. Is that what you are looking for? Miguel. "Jeanie" wrote: how do i form a ratio. is there a formula? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |