LCM (Least Common Multiple) is an Excel function that returns the least common multiple of values. The least common multiple is the lowest integer (a number without fractional component) that is a multiple of all the selected numb...
EDATE and EOMONTH are two date functions you can add to your Excel 2010/13 spreadsheets. These are functions that return that add or subtract months from a specified date. EMONTH returns the last day of the month and EDATE adds or...
GCD (Greatest Common Denominator) is another function you can add to Excel 2010/13 spreadsheets. The function finds the greatest divisor between two or more integers (numbers without fractional components). It returns the largest ...
This post covered the FACT Excel function that you can find factorials with. You can also find double factorials with Excel 2010/13. The double factorial is the product of all integers from one up to a non-negative integer n with ...
A nominal interest rate for a loan is one that does not factor in compound interest. However, as interest rates are compounded monthly, or quarterly, the effective rate of loan interest is slightly higher. To find the effective ra...
Excel has numerous functions that you can add to spreadsheets. Among them are ODD and EVEN. Those are functions that round numbers to the closest odd or even values. To add the ODD function to spreadsheets, click the fx button. Th...
Excel 2010/13 has a variety of financial functions. Among them is the ISPMT function, which returns the interest paid for a specific period of a loan. The ISPMT sysntax is ISPMT(interest_rate, period, number_payments,PV). For exam...
Excel isn’t the best application for setting up databases. However, you can still set up smaller flat-file (single table) databases with the software. It includes a variety of database functions among which are DMAX and DMIN...
FV (Future Value) is a financial function you can add to Excel spreadsheets. This is a function that returns the future value of an investment based on regular periodic payments and a fixed rate of interest. An investment such as ...
AVERAGEIF is an Excel 2010/13 function that returns average values based on specified criteria. For example, if you have a data table you can add an AVERAGEIF function to a cell to find average values from one column that match cr...
MODE and MEDIAN are two functions you can add to Excel spreadsheets to find averages from a range of values.Mode is the most frequently occurring value from a data range. Median is the middle number in a given set of values. For e...
Handling images in Word can be quite tricky. For example, you’ll need a workaround for adjusting image transparency. It can also be difficult to move an image to any place or position that you like. As for the latter, there’s no n...
MOD and QUOTIENT are two Excel 2010/13 functions you can add to spreadsheets to find the remainder and integer portion of a division between values. These are functions that require just two values. Enter a number and divisor to f...
RANK.AVG and RANK.EQ are new Excel 2010 functions. They aren’t included in other versions except Excel 2013. These functions show you the statistical rank of a value within a list. So the rank tells you their order in a list of va...
EXACT is a function you can add to Excel 2010/13 spreadsheets. This function compares two values (text or numerical) in two cells and tells you if they match or not. If they match it returns TRUE, and if they don’t it returns FALS...
