Hi
Yes the checkbox Update this value when the result of the formula is recalculated is selected. I have tried it with the checkbox de-selected as well. I am very perplexed (to put it mildly), all of the forum posts, on this and other forums, say that it should work.
Thanks
Gary