Combined with the logical functions such as AND OR and NOT the IF function has even more value because it allows testing multiple conditions in desired combinations. In this tutorial we will focus on using IF. Basic example Excel Text Function.
IFC2 1 then return Yes otherwise return NoAs you see the IF function can be used to evaluate both text and values.
Text function in excel is categorized under string or text function in excel and this is a very useful function which is used to. The INDIRECT function allows you to create a reference from a text string. Use INDIRECT to create a reference from a text string. This is so as no optional arguments are specified and hence Excel took the current locale.