View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default Make T=True in a cell, when I enter T

A formula won't work in the same cell, if that's what you had in mind, but
this formula will work in another cell....

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

Vaya con Dios,
Chuck, CABGx3


"A357Magnum" wrote in message
...
How can I set a formula to recognize a T and automatically place TRUE in

the
cell?