I have tried using Excel 2003, the formula worked well.
How about give us the file