Thread: Change "FALSE" to "NO DATA"
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AAA1986 AAA1986 is offline
external usenet poster
  
Posts: 16
Default Change "FALSE" to "NO DATA"
Right now I have the following function in a cell column:

=IF(P18="PMR",E$26)

But when the referenced cell does not equal "PMR" it turns up as "FALSE".
Can I change this so it turns up as "NO DATA"?

Thanks in advance.
Reply With QuoteReply With Quote