I don't know why the formula is not working for you. If you're still
getting the same error -- "The formula you typed contains an error" --
then, as far as I know, that means that the syntax is incorrect.

But, as I previously mentioned, the syntax is correct. So, unless
you're entering the formula incorrectly, I don't know what the problem
could be.

Hopefully some else might be able to help.


---
Message posted from http://www.ExcelForum.com/