The IF function runs a logical test and returns one value for a TRUE result and another for a FALSE result. EXCEL FUNCTIONS FULL LIST This is a complete alphabetical list of all the Functions in Excel with a description. Here is another example of using Insert Function to help with the Sum Function.
If And in excel are the two most different functions which are usually nested together in a simple If function we can only test a single criteria but if we use the logical AND function we can test more than one criteria and give output based on the criteria they are used as follows IF Condition 1 AND Condition 2 Value if true Value if False.
As the name If defines condition so it will look for a certain condition. Formulas Functions 9 Exercise. As the name If defines condition so it will look for a certain condition. Excel String Text Functions.