how to express as a ratio?

  • Thread starter Thread starter yao
  • Start date Start date
Y

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
 
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!
 
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"
 
Back
Top