What is the ROUNDDOWN Function? The ROUNDDOWN Function is categorized under Excel Math and Trigonometry functions. The function will round down towards zero. Basically, it does the opposite of the ROUNDUP function. As a financial analyst, this function is useful as it helps round a number and eliminates the least significant digits, simplifying the notation…
What is the ROUND Function? The ROUND Function is categorized under Excel Math and Trigonometry functions. The function will round up a number to a specified number of digits. Unlike the ROUNDUP and ROUNDDOWN functions, the ROUND function can round either up or down. As a financial analyst, this function is useful as it helps…
Put-Call Parity Excel Calculator This put-call parity calculator shows the relationship between a European call option, put option, and their underlying asset. By inputting information, you can see what any of these variables should be if this parity relationship were to be held. Below is a quick preview of CFI’s put-call parity calculator: Download the…
What is the RANDBETWEEN Function? The RANDBETWEEN Functionis categorized under Excel Math and Trigonometry functions. The function will return a random integer number between the user-specified numbers. It will return a random integer number every time the worksheet is opened or calculated. As a financial analyst, the RANDBETWEEN function can be used to generate random…
What is the RAND Function? The RAND Function is categorized under Excel Math and Trigonometry functions. The function will return a random number between 0 and 1. It provides a real number that will be returned every time the worksheet is opened. As a financial analyst, the RAND function can be used to generate random…
What is the ODD Function? The ODD Function is classified as an Excel Math and Trigonometry function. It will round a specified number away from zero to the next odd number. The function will round a positive number up and a negative number down. As a financial analyst, ODD is a very useful function, as…
What is the SUM Function? The SUM Function is categorized under Excel Math and Trigonometry functions. The function will sum up cells that are supplied as multiple arguments. It is the most popular and widely used function in Excel. SUM helps users perform a quick summation of specified cells in MS Excel. For example, we…
What is the TRUNC Function? The TRUNC Function is an Excel Math and Trigonometry function. It removes the fractional part of a number and, thus, truncates a number to an integer. It was introduced in MS Excel 2007. In financial analysis, the function can be used to truncate a number to a given precision. It…
What is the SUMPRODUCT Excel Function? The SUMPRODUCT Function is categorized under Excel Math and Trigonometry functions. The function will multiply the corresponding components of a given array and then return the sum of the products. It is used to calculate a weighted average. As a financial analyst, SUMPRODUCT is a very handy function, as…
What is the SQRT Function? The SQRT Function is an Excel Math and Trigonometry function. It will provide the square root of a positive number. The function was introduced in MS Excel 2010. Formula for the SQRT Function =SQRT(number) The SQRT function uses the following argument: Number (required argument) – This is the number for…
