View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sweetetc
 
Posts: n/a
Default Can you replace "TRUE" with " " in an exact formula?

Excellent It worked like a charm!
--
Thanks
ETC


"Chip Pearson" wrote:

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