Hi guys,
First of all I would like to say hello to everyone on the forums .
Now I was hoping someone might be able to help me with an issue I'm having with a formula in exel. I have been trying to find a solution for two days now and can not find it, so I was hoping some one here might be able to help.
I have atached a workbook with the formula and the cells I am trying to calculate.
Here is the problem;
I have two colums which contain data, one has measurements(first column) and the other has a deviation from the mean value (second column) calculated from all the measurements in the first column.
The formula I have created seems to work untill I get a zero reading, once a zero reading has been calculated it seems to throw back random numbers rather than leaving the cell as zero.
I think the problem might be to do with circular reference that I am being warned about when I open the work book.
So basicaly what I would like the formula to do Is return a zero in the deviation column if the measurement column reads zero, and also if possible would I be able to have a + sign in front of my positive values in the deviation column.
I hope this makes sense, and someone might be able to help me.
Thank you for you time.
Rgds,
Spacemonkey.
Bookmarks