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 |
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 |
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". |
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 |
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 |
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 |
All times are GMT +1. The time now is 04:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com