Hi Everyone, I have a nested IF function:
=IF(D3<=D$243,1,IF(D3<=D$244,2,IF(D3<=D$246,4,IF(D3<=D$247,8,IF(D3<=D$248,16,32)))))
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,