Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
?
Lv 7
? asked in Computers & InternetSoftware · 7 years ago

EXCEL formatting?

I've calculated the Mean and Standard Deviation in 2 separate cells. Let's say the Mean is displayed in cell A1, and the Standard Deviation is displayed in cell A2.

I want to display the results as Mean±SD in cell A3.

For example, if A1 contains 34.3 and A2 contains 4.12, I would like A3 to display

34.3 ± 4.12 cm

Can anyone tell me how to do this, please?

Thanks in advance.

1 Answer

Relevance
  • Seabee
    7 years ago
    Favorite Answer

    =A1&" "&CHAR(177)&" "&A2&" cm"

Still have questions? Get your answers by asking now.