Prabha,

Take a look at the syntax of your ISNA function.
The previous post answered to your question already.

You should lose the ="" after the ISNA parenthesis.

The syntax for ISNA is (as Frank already noted):
IF ( ISNA ( formula ), "", formula ) , and not: IF ( ISNA (formula )
"", "", formula)

I believe that's the way all IS functions work (ISERROR etc.).

This could also have been resolved by using Excel's help.

Regards,
Ale

--
Alex Hatzisava
-----------------------------------------------------------------------
Alex Hatzisavas's Profile: http://www.excelforum.com/member.php...fo&userid=1455
View this thread: http://www.excelforum.com/showthread.php?threadid=26164