conversion ratio

  • Thread starter Thread starter iceicebaby
  • Start date Start date
I

iceicebaby

Im trying to take to cells and output it like this to another cell.

say if cell (A) has the number 100 and cell (B) has the number 5 I want
to divide a into b and have it output a conversion ratio...
Like below....HELP
I can get the number 20 but don't know how to add the 1: in front of
it.
1:20
 
-----Original Message-----
Im trying to take to cells and output it like this to another cell.

say if cell (A) has the number 100 and cell (B) has the number 5 I want
to divide a into b and have it output a conversion ratio...
Like below....HELP
I can get the number 20 but don't know how to add the 1: in front of
it.
1:20
Click to expand...
use the CONCATENATE function
e.g. =CONCATENATE(1,":",A1/B1) or =CONCATENATE("1:",A1/B1)
 
Back
Top