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

Dear Frank and Alex,
Very many thanks for your advise. It works perfect!.
Shouldn't have missed that with my big fat glasses on!!
Best wishes
Prabha

"Alex Hatzisavas" wrote:


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,
Alex


--
Alex Hatzisavas
------------------------------------------------------------------------
Alex Hatzisavas's Profile: http://www.excelforum.com/member.php...o&userid=14559
View this thread: http://www.excelforum.com/showthread...hreadid=261644