On Tue, 10 Feb 2009 16:39:00 -0800, srctr
wrote:

It still doesn't work, It gives me an error "the formula you typed has an
error". Should I have the cell formatted already a certain way?

--
cao

What version of Excel do you have?

It should work in 2007.

It won't work in earlier versions because of nesting limitations.
--ron