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