Excel has a number of logical functions which allows you to set various "conditions" and have data respond to them. For example, you may only want a certain calculation performed or piece of text displayed if certain conditions are met. To start using Functions in Excel you need to Open Excel => Click in a cell => Click on Insert Menu button => Function Lets consider a simple example. When we are in a restaurant and have X amount of money, we compare that the dish we select costs less than or equal to the amount we have (in this case X amount). Your selection is based on the condition that the price of the dish should be less than X amount. We can do similar calculations in Excel. IF STATEMENT The IF function is used to analyze data, test whether or not it meets certain conditions and then act upon its decision IF statement is accompanied by three arguments enclosed in one set of parentheses; the condition to be met (logical_tes...