Thread: result if a condition is NOT true?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joel joel is offline
external usenet poster
  
Posts: 9,101
Default result if a condition is NOT true?
To compare text (not boolean true or false) then you need to use strcomp().

"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