The TEXT function takes two arguments value and format_text.
How to use if function text in excel. For example to pass scores above 70. If you want a case-sensitive logical test use the IF function in combination with EXACT that compares two text strings and returns TRUE if the strings are exactly the same otherwise it returns FALSE. Lets begin by selecting cell B5 and entering the following IF formula.
IF A5ATAT Notice the formula returns nothing even though the text in cell A5 contains the letter sequence AT. To test for cells that contain certain text you can use a formula that uses the IF function together with the SEARCH and ISNUMBER functions. The TEXT function will convert numbers to text which may make it difficult to reference in later calculations.
Select the cell where you want to insert the IF formula. The PROPER function has only one argument. Insert the condition that you want to check followed by a comma.
TEXT function is language-specific. So if those two text values are exactly the same then return TRUE. The text itself or a cell that contains the text.
But it in reality the Text function is used to convert any value in text format and we can even change the format of converted value as well. Excel IF Function The IF function runs a logical test and returns one value for a TRUE result and another for a FALSE result. Then if you need to build other formulas always reference the original value and not the TEXT function.
In this example the formula in cell D2 says. You can use the TEXT function to embed formatted numbers inside text. If value is already text no formatting is applied.