But more like,
=if(A1="TRUE","Yes","No")


If A1 is True or False, (and it is) then

what I gave you is sufficient.

A1="True"

will convert either "True" to the boolean value True or Change the Boolean
Value True in A1 to "True" to do the comparison and then return the boolean
value True.

Sounds like the long way around the block when A1 already contains a boolean
True (or False)

To summarize if that wasn't clear - you don't need to change anything I
provided.

--
Regards,
Tom Ogilvy


wrote in message
oups.com...
Wow thanks for the quick reply.

Seems like a good method. But more like,
=if(A1="TRUE","Yes","No")

I may need quotes around the TRUE part.

Very cool, thanks,
Jason