I need help with ratios
Hi,
Assuming Cells A2 divided by B2, how about:
=concatenate(A2/B2,":1")
HTH,
Alain
"Cin" wrote:
I need to take information in 2 different cells, divide it, and show the
result as a ratio 2:1.
I know how to set the formula to divide the 2 cells, but the result is a
percentage, not in the format I need to see, which is 2:1.
Help?
|