Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you replace "TRUE" with " " in an exact formula?
-- Thanks ETC |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy exact value from one cell to new formula in another cell | Excel Discussion (Misc queries) | |||
Replace data with the result of a formula | Excel Discussion (Misc queries) | |||
Replace a spreadsheets named cells/ranges with exact cell address. | Excel Discussion (Misc queries) | |||
Use of the DSUM formula to find exact matches in datatables | Excel Worksheet Functions | |||
How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) |