Someone asked, " How to convert Logical Text to Logical Value in Excel? " In more details, his question like, you have below data table: Image 1: Logical Text to Logical Value The D2 cell contains a formula and it will show the logical result like: =CONCATENATE(A2,B2,C2) as TRUE or FALSE . More specifically he wanted: =IF(CONCATENATE(A2,B2,C2),"Logical","Illogical") But according to Microsoft Excel, if you apply CONCATENATE function then the value always returns TEXT and IF function will always return FALSE that means " Illogical ". He wanted if he change the logical operator symbol in B2 cell, then depends on this logical operator symbol, the result in D2 cell of =CONCATENATE(A2,B2,C2) will change as TRUE or FALSE . Solution: After studying on it, I've found a simple solution. And the solution is why don't we use a IF formula on this? Yes, an IF formula can help us regarding this issu...
Learn Microsoft Excel with step by step tutorials including charts, formulas, functions, Power BI, Excel VBA for beginners.