Hyperlinking when it shouldn't...
 

This is my code:

=IF(K60,IF(O6,HYPERLINK(L6),HYPERLINK(RIGHT(L6,N6-M6))),"N/A")

The "N/A" part of it executes only if K6 is not greater than zero. The N/A
is being put in the cell when it is supposed to, but it is is put in as a
hyperlink so the cursor turns into a hand when put over it, and if the user
clicks it, a message comes up with the office assistant saying it cannot open
the specified file. The format for the whole column this formula is used in
is 'general'.
I don't understand why the N/A is put in as a hyperlink instead of plain
text. What am I missing?

I am using Excel 2002.

Thanks,
Lori