how to express as a ratio?

[yao]

I'm trying to figure out how to express two data series
as a ratio, (e.g. 14:1) rather than as a fraction. Any
ideas?

Cheers,
yao

 

[Dave R.]

Do you want to display them as ratios, or be able to use ratios in
calculations?

 

[yao]

display as ratios. . . the excel addict recommended this:

="1:" & ROUND(B2/C2,x) where x is the number of digits
you want expressed. thanks, francis!

 

[Dave R.]

B2 = 1, C2=4

2 data series as a ratio? =+B2&":"&C2 = "1:4"

B2 = .25
1 value as a ratio? =+"1:"&ROUND(1/B2,4) = "1:4"