AND Function in Excel

The Excel AND function is a logical function used to require more than one condition at the same time. AND returns either TRUE or FALSE. To test if a number in A1 is greater than zero and less than 10, use =AND(A1>0, A1<10). The AND function can be used as the...

VLOOKUP IN EXCEL

The VLOOKUP Function in Excel is a tool for looking up a piece of information in a table or data set and extracting some corresponding data/information.  In simple terms, the VLOOKUP function says the following to Excel, “Look for this piece of information (e.g.,...

Date Function

The Excel DATE function creates a valid date from the individual year, month, and day components. The DATE function is useful for assembling dates that need to change dynamically based on other values in a worksheet. Purpose  Create a date with year, month, and...