TRUE or FALSE Cell Content

[rhmkrmi]

Hello,

I have a column where cells are populated with text TRUE or FALSE.
What formula can I use to check if the cell text content in TRUE or FALSE?
I tried IF(A1="TRUE","TRUE",IF(A1="FALSE","FALSE")) but it returns FALSE even when the cell text content is TRUE.

Thanks.

 

[Cubist]

Try

=IF(A1 = "TRUE", TRUE, FALSE)

 

[StephenCrump]

What exactly do you have in A1?

If your formula is failing, it means that the formula =A1="True" would return the boolean FALSE. This could be the case if A1 contains "TRUE", for example, rather than the text value 'TRUE

	A	B
1	"TRUE"	FALSE
2	TRUE	TRUE
3	TRUE	TRUE
Sheet1

Cell Formulas
Range	Formula
A2	A2	=IF(1=1,"TRUE","FALSE")
B1:B3	B1	=A1="TRUE"

You'd be better off using boolean TRUE/FALSE throughout, rather than text values.

 

[rhmkrmi]

What exactly do you have in A1?

If your formula is failing, it means that the formula =A1="True" would return the boolean FALSE. This could be the case if A1 contains "TRUE", for example, rather than the text value 'TRUE

	A	B
1	"TRUE"	FALSE
2	TRUE	TRUE
3	TRUE	TRUE
Sheet1

Cell Formulas
Range	Formula
A2	A2	=IF(1=1,"TRUE","FALSE")
B1:B3	B1	=A1="TRUE"

You'd be better off using boolean TRUE/FALSE throughout, rather than text values.

Thank you.

In cell A1 I have a free text value as TRUE without single or double quotes.

I have not entered these values.
The spreadsheet that I am using is a report output imported into Excel.
Column A has free text values in cells as either TRUE or FALSE.

Thanks again.

 

[Scott Huish]

If A1 contains TRUE or FALSE and you want to return TRUE or FALSE, why can't you just use =A1

 

[rhmkrmi]

Here is a sample:

Thanks.

 

[StephenCrump]

In cell A1 I have a free text value as TRUE without single or double quotes.

Are you sure it's not a boolean TRUE?

What result do you get for:

B1: =A1=True

 

[Cubist]

The values are centred it looks like they're already Boolean and not text.

What happens when you do

=ISLOGICAL(A1)

 

[Alex Blakenburg]

This will handle both Boolean and Text but it is hiding the problem which you are perpetuating by using TRUE and FALSE as output of the If statement.

= IF(A1&""="TRUE","TRUE",IF(A1&""="FALSE","FALSE","NA"))

As Cubist and Stephen have mentioned it is likely that the current value is Boolean which means you don't need the quotes.
It would be better to understand what you are wanting to achieve,

 

[rhmkrmi]

Are you sure it's not a boolean TRUE?

What result do you get for:

B1: =A1=True

I get correct results when I try your formula.