Thread: Can you replace "TRUE" with " " in an exact formula?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson
 
Posts: n/a
Default Can you replace "TRUE" with " " in an exact formula?
Try something like

=IF(EXACT("abc","abc"),"",FALSE)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Sweetetc" wrote in message
...

--
Thanks
ETC


Reply With QuoteReply With Quote