add text to formula

[howard]

I have the following formula which gives me 0.52 . I want the result to appear for eg as 0.52:1, 0.59:1 etc


=B79/B5 result in this instance 0.52


I tried to amend it as ="B79/B3 "&1&":1" and the end result is B79/B3 1:1


It would be appreciated if someone could kindly amend my formula

 

[Joe4]

Remember, anything placed between double-quotes is treated as literal text. So do NOT place your cell references between them!
You want something like:
=B79/B3 & ":1"
or
=ROUND(B79/B3,2) & ":1"
if you want to be sure to limit it to two decimal places.

 

[njimack]

=b79/b3&":1"

 

[louisH]

Hi,

Wouldn't just ="B79/B3 &":1"

 

[njimack]

Another option would be to leave the formula as is, and change the formatting of the cell to 0.00":1"

 

[Marcílio_Lobão]

howard, Good morning.

Try to use:

=B79/B5 & ":1"

Is that what you want?

I hope it helps.

 

[howard]

Thanks for the help guys, much appreciated