If that's the case, which I don't believe it is, then why did the
other formula work?

On Sat, 5 Jan 2008 22:46:36 +0800, "Max" wrote:

Actually, no. That returned a value error.

You've got text or formula returned errors then in the range,
which you didn't exactly reveal in your orig. posting

It would have worked otherwise.