Nested IF Function Returning All Zero

Hi Everyone, I have a nested IF function:

Please Login or Register  to view this content.

I am dragging this across a number of cells all formatted as "general" and I am getting nothing but "0". All of the cells referenced contain numbers.

I was able to fix this earlier by deleting everything and re-writing the formula. That caused the first cell to give me a zero, but the cells that the formula was dragged to calculated correctly. Then I had to drag the formula over the original cell to get the zero to change to the proper value.

Now even re-writing the formula does not help. It was working originally until I changed a couple of the numbers and added the $ which caused it to cease working.
Very frustrating, any ideas?
Thanks,

Hi,
It turns out that the numbers the formula was referencing contained a circular reference. I fixed that and now it works.