How can I set a formula to recognize a T and automatically place TRUE in the cell?
A A357Magnum Jan 20, 2006 #1 How can I set a formula to recognize a T and automatically place TRUE in the cell?
C CLR Jan 20, 2006 #3 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
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
S Sandy Mann Jan 20, 2006 #4 I sometimes think that it may casue as many problems as it solves but try Tools > Autocorrect and replace t with TRUE. Note that t will replace both T and t with TRUE but T will only replace T and it will leave t as it is. -- HTH Sandy [email protected] [email protected] with @tiscali.co.uk
I sometimes think that it may casue as many problems as it solves but try Tools > Autocorrect and replace t with TRUE. Note that t will replace both T and t with TRUE but T will only replace T and it will leave t as it is. -- HTH Sandy [email protected] [email protected] with @tiscali.co.uk
