Thread: How do I eliminate "false" from showing in a cell?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey
 
Posts: n/a
Default How do I eliminate "false" from showing in a cell?
How is FALSE getting there?

Assuming it's due to an IF() statement, put what you want to appear in
the third argument:

=IF(A1<B1,"It's true","It's not true")

If you want the cell to *appear* blank:

=IF(A1<B1,"It's true","")




In article ,
thistooshallpass wrote:
Reply With QuoteReply With Quote