To the most avid problem solver,
I have two columns; values and there corresponding standard errors. I really want to find a way to show the value and the standard error in one cell, e.g. 14±3 %, so I can copy/paste straight into my word doc! Its been suggested to ctrl+P straight into word and just adjust it, but the figures are falling out a model that is always updating itself and I have tonnes of these bad-boys to go.
So, Y4 = 14% (value)
and Y5 = 3% (s.e.)
and Y6 = "±" (from symbols)
I have nailed it up to a point...
=LEFT(Y4,4)&Y6&LEFT(Y5,4)
= 0.14±0.03
...but I can't get it to show the values as percentages with a % at the end!!?? I have tried custom formatting but once I'm at this stage it won't really affect it (and it confuses me anyway).
Any good ideas??
Bookmarks