AND returns either TRUE or FALSE. The IF function is used to run a logical test and react differently depending on whether the result is TRUE or FALSE. By default excel has already provided us with many types of conditional formatting available to do with our data but if any user wants the formatting done on specific criteria or formula we can do so in the home tab of the conditional formatting section when we click on the new rule we will find an option for conditional formatting with formulas where we can write formulas which will define the cells to format.
For example cell A3 below contains the SUM function which calculates the sum of the range A1A2.
Click Evaluate multiple times. To divide use the sign. Functions are predefined formulas that perform calculations by using specific values called arguments in a particular order or structure. To multiply use the sign.