Calculating Standard Deviation result from the mean

[jhase1]

I am looking for a way in excel to calculate what the value of a particular Standard deviation from the mean. For example:

Mean: 10
Standard Deviation: 1.75

Question: What would be the value of 1.75 standard deviation from 10?

Thanks!

 

[63falcondude]

https://answers.yahoo.com/question/index?qid=20130913114301AA4SwMf

 

[63falcondude]

If µ = 10 (in cell A1) and σ = 1.75 (in cell A2) then the value that is 1.75 standard deviations from 10 is =A1+1.75*A2 and =A1-1.75*A2 which will be 13.06 and 6.94 respectively.

 

[jhase1]

Thanks Falcondude! It worked very well

 

[63falcondude]

Glad to help!