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.

 

[rhmkrmi]

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

What happens when you do

=ISLOGICAL(A1)

When I use your formula, it returns TRUE for all of them.

 

[Alex Blakenburg]

An alternative to what I posted previously is to use Trim:

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

 

[Cubist]

When I use your formula, it returns TRUE for all of them.

That means they're boolean and not text.

 

[Scott Huish]

So =A1 should work