ratio

[Matt]

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

 

[Max]

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

 

[JoeU2004]

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".

 

[Matt]

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

 

[Matt]

1/5000

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

 

[Max]

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