As we can see the above screenshot we have applied COUNTIF function to find out Student marks not equal to 50. Ts Symbol in excel is used to lock a specific cell or rows or columns in a worksheet the shortcut to lock down a reference in excel is by pressing ALT F4 this feature is used while working in formulas when we do not want the reference to be changed when we copy or drag down the formula to other cell references this feature will keep the reference same for all the further calculations. String1 to string_n are the string values to concatenate together.
This blog post looks at using the IF function to display a symbol conditionally in a cell.
For example formula A1B1 returns TRUE if cells A1 and B1 contain the same value number text. On the Home tab in the Number group click the percentage symbol to apply a Percentage format. Similarly to the CONCATENATE function you can use in Excel to combine different text strings cell values and results returned by other functions. In Excel you can use the ampersand operator or concatenate or join separate text strings together.