I have worked a wat around this, although still mystified by the problem.

The formulas work exactly as they are supposed to if the named range is a
single cell only AND referred toin the formula by its cell address. It
appears to be using a named range that is causing the problems. :-(