Function T()

T()

This function is used to check whether a cell contains any text or not, and if it contains text that text should be pulled out to cell in which this function is used.

Though this function is very rarely used, it has good utility in its application


Syntax:

= T (Cell)

Cell = cell that is to be checked for containing text


Example:

Below are some examples to illustrate the usage of Proper() function. For these illustrations let us assume that cell A1 contains text - Excel Matic, cell A2 contains 25.65 and cell A3 contains Force5.
  • = T(A1) - result will be - Excel Matic
  • = T(A2) - result will be -
  • = T(A3) - result will be - Force5
  • = T("Excel Matic") - result will be - Excel Matic
  • = T(30.77) - result will be -
  • = T("30.77") - result will be - 30.77
  • = T("Force5") - result will be - Force5
Note: In the above example #6, the result will be 30.77 because in the function the input itself is a text. Whenver a number is input in double quotes ( "text" ), the numeric value becomes text.
Share on Google Plus

About Rishie Khurana

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.
    Blogger Comment
    Facebook Comment

0 comments:

Post a Comment

Saturday, May 30, 2009

Function T()

T()

This function is used to check whether a cell contains any text or not, and if it contains text that text should be pulled out to cell in which this function is used.

Though this function is very rarely used, it has good utility in its application


Syntax:

= T (Cell)

Cell = cell that is to be checked for containing text


Example:

Below are some examples to illustrate the usage of Proper() function. For these illustrations let us assume that cell A1 contains text - Excel Matic, cell A2 contains 25.65 and cell A3 contains Force5.
  • = T(A1) - result will be - Excel Matic
  • = T(A2) - result will be -
  • = T(A3) - result will be - Force5
  • = T("Excel Matic") - result will be - Excel Matic
  • = T(30.77) - result will be -
  • = T("30.77") - result will be - 30.77
  • = T("Force5") - result will be - Force5
Note: In the above example #6, the result will be 30.77 because in the function the input itself is a text. Whenver a number is input in double quotes ( "text" ), the numeric value becomes text.

Function T()SocialTwist Tell-a-Friend

0 comments:

Post a Comment