Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ratio
Its there a way i can do ratio. I have cell a1 with 163 and 463000 in cell A2
and I would like the ratio in cell A3. Is there a way to do this? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
ratio
Can you show us the exact result that you expect to display in A3?
-- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Matt" wrote: Its there a way i can do ratio. I have cell a1 with 163 and 463000 in cell A2 and I would like the ratio in cell A3. Is there a way to do this? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
ratio
"Matt" wrote:
Its there a way i can do ratio. I have cell a1 with 163 and 463000 in cell A2 and I would like the ratio in cell A3. Is there a way to do this? Thanks What would you like the ratio to look like? For example, in its simplest form, perhaps: =A2 & ":" & A1 might yield 463000:163. More reliably (in case A1 or A2 has decimal fractions): =text(A2,"0:") & text(A1,"0") But if you want the ratio to always be ":1", perhaps: =text(A2/A1,"0.0:") & ":1" However, note that none of those forms is a numeric. If you would like to be able to treat the ratio as a number, and you always want ":1", try: =A2/A1 with the custom format 0.0:"1". |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
ratio
What I have is we processed 463000 pieces and we had 163 errors so i need
cell A3 to show the ratio like 1/5000 Thanks "Max" wrote: Can you show us the exact result that you expect to display in A3? -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Matt" wrote: Its there a way i can do ratio. I have cell a1 with 163 and 463000 in cell A2 and I would like the ratio in cell A3. Is there a way to do this? Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
ratio
1/5000
"Max" wrote: Can you show us the exact result that you expect to display in A3? -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Matt" wrote: Its there a way i can do ratio. I have cell a1 with 163 and 463000 in cell A2 and I would like the ratio in cell A3. Is there a way to do this? Thanks |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
ratio
Maybe something like this then,
in A3: ="1:"&ROUND(A2/A1,-3) Adapt to suit -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Matt" wrote: What I have is we processed 463000 pieces and we had 163 errors so i need cell A3 to show the ratio like 1/5000 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ratio function | Excel Worksheet Functions | |||
Ratio | Setting up and Configuration of Excel | |||
Ratio | Excel Discussion (Misc queries) | |||
Divide x/y should give Ratio x:y,How to express ratio in excel | Excel Worksheet Functions | |||
Ratio function | Excel Worksheet Functions |