The TODAY Function
It returns the serial number of the current date.
It returns the serial number of the current date.
It combines three separate values to form a date and returns that date.
It returns TRUE if the formula you specify leads to an error. If there is no error in the formula ISERROR returns FALSE.
It returns a value you specify if a formula leads to an error. If there is no error in the formula IFERROR returns its result. It is part of the logical functions of Excel.
It returns the inverse of a logical value. If a logical value is TRUE it returns FALSE and vice versa. It is part of the logical functions of Excel.
It is used to make logical comparisons between two values and return two results. One if the comparison is TRUE and one if the comparison is FALSE. It is part of the logical functions of Excel.
It is used to determine if any of the conditions in its arguments is TRUE. If even one of its arguments is TRUE the function will return TRUE. It is part of the logical functions of Excel.
It is used to determine if all the conditions in its arguments are TRUE. If even one of its arguments is FALSE the function will return FALSE. It is part of the logical functions of Excel.
It calculates the annual yield for a discounted security.
It calculates the annual yield for a discounted security.