Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 04-18-2010, 12:38 AM
RolandVet RolandVet is offline deviation Windows 7 deviation Office 2007
Join Date: Apr 2010
Posts: 3
RolandVet is on a distinguished road
Default deviation


I want excel to calculate the multiples of two cells... say A1 and A2
Say A1 is 3 and A2 is 2... the calculated value is 6
That was the easy part.
Now my measure results were not exactly 3, they were say 3+-0.5. Now I want excel to take this deviation into consideration and give me the correct answer. This is supposed to be done by taking the two extreme values, calculating the answer, then averaging them and then also adding the std dev.

answer is 6 +- 1

Now i've tried to use +- and the mathematical equivalent from symbols but as soon as i add these symbols, excel does not register the data in the cell as a number, but as text thus leading to no calculation.

I know this can be done by using alot of extra cells and some complicated formulas but is there no easy way to do this?
Reply With Quote

Thread Tools
Display Modes

All times are GMT -7. The time now is 08:43 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd. is not affiliated with Microsoft