Thread: result if a condition is NOT true?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Mike is offline
external usenet poster
  
Posts: 3,101
Default result if a condition is NOT true?
In any cell will check if A1 is false and if true return the value of A2 or
unspecified if false.

=IF(A1=FALSE,A2,"Unspecified")

Mike

"Roland" wrote:

How do I get XL to report the value of a cell if a (text) value in another
cell is NOT true?
Reply With QuoteReply With Quote