ExcelBanter - Can you replace "TRUE" with " " in an exact formula?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Can you replace "TRUE" with " " in an exact formula? (https://www.excelbanter.com/excel-worksheet-functions/70725-can-you-replace-true-exact-formula.html)

Sweetetc

Can you replace "TRUE" with " " in an exact formula?

--
Thanks
ETC

Chip Pearson

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

Sweetetc

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

All times are GMT +1. The time now is 06:23 AM.