Hey Excel Forum community,

This is a bit of a strange one. I have an array formula with a lot of components to it so I won't explain all of the logic here. The puzzle is that the formula is returning zero even though stepping through the evaluate formula to the final stage shows that the answer should be around 0.34 (see screenshots attached)

screenshot1.png

screenshot2.png

It is not a problem with decimal places or cell formatting as far as I can see. Searching the forum and google hasn't come up with anything. Has anyone encountered and conquered this problem before?

Cheers,
Griffin