Monthly Archives: April 2019

The OR Function

Kornilios Ampatzis/ April 25, 2019/ Functions

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.

The AND Function

Kornilios Ampatzis/ April 25, 2019/ Functions

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.

The YIELD Function

Kornilios Ampatzis/ April 22, 2019/ Functions

It calculates the yield on a security that pays periodic interest.

The PRICEMAT Function

Kornilios Ampatzis/ April 22, 2019/ Functions

It calculates the price per $100 face value of a security that pays interest at maturity.

The PRICE Function

Kornilios Ampatzis/ April 22, 2019/ Functions

It calculates the price per $100 face value of a security that pays periodic interest.

The RECEIVED Function

Kornilios Ampatzis/ April 22, 2019/ Functions

It calculates the amount received at maturity for a fully invested security.

The ACCRINTM Function

Kornilios Ampatzis/ April 22, 2019/ Functions

It calculates the accrued interest for a security that pays interest at maturity.