It starts from the very basics and within a few minutes you will be having a good command over basic excel functions and even some advanced and frequently used features. AND returns either TRUE or FALSE. Converts a serial number to a day of the month.
Instead we want to input different information into a cell if there is a corresponding cell with that information.
IF function in Excel checks whether a condition is met and if its TRUE it returns a value and another value if the condition does not meets FALSE. Credit Barry Masterson - Entrepreneurial Ideas. AND returns either TRUE or FALSE. Formulas and Functions Enter a Formula.