Combing cells

[Markiup]

Good afternoon Excel gurus ,

If I have to columns in one column I have 3M Libor in the column next to it 1.18. How do I make the 3rd column read 3M Libir +1.180%?

I tried =If(A1 "&text("B1,000%")

Its not working. Anyone got anything better?

Thanks in advance

 

[Joe4]

Try:

=A1 & " +" & Text(B1,"0.000%")

 

[Markiup]

Thank you that worked great. What if the percent is 1.7 and one is 1.81. How do I make sure they all go to thousandth. 1.700 and 1.810?

 

[Joe4]

What if the percent is 1.7 and one is 1.81. How do I make sure they all go to thousandth. 1.700 and 1.810?

Did you try it? That formula already does that. It will always have three numbers after the decimal point.

 

[Markiup]

This current formula makes it go from 1.18 to 118.000% . I need 1.180%. I'm probably missing something easy

 

[Markiup]

Sorry I got it. It was my mistake. Thank you for your help!

 

[Joe4]

Percents are actually fractions/decimals (100% is actually equivalent to 1).

So 1.18% is really equal to .0118, not 1.18.
So if your data is originally showing 1.18, you need to account for like by dividing by 100 this:

=A1 & " +" & Text(B1[COLOR=#ff0000]/100[/COLOR],"0.000%")