Excel Formulas

A blog for publishing examples of Excel formulas.

Formulas for Week Numbering in Excel

›
Using the ISO or U.S. week number is common when calendars and other templates are used for project planning.
1 comment:

Formula for Converting Dollar Amount to Words

›
The article on Microsoft.com " How to convert a numeric value into English words in Excel " provides some VBA code for converting ...
6 comments:

Calculating Holidays like Victoria Day

›
I recently was asked how to use an Excel formula to calculate the date for the Canadian holiday Victoria Day .
2 comments:

Annuity Formula

›
The PV, FV, NPER, RATE, and PMT functions in Excel can be used for both an ordinary annuity (payments made at the end of the period, type =...
6 comments:

NPV Formula

›
To calculate Net Present Value using the NPV formula in Excel, you need a series of periodic cash flows like that shown in the figure belo...
1 comment:

IRR Formula

›
To calculate Internal Rate of Return using the IRR formula in Excel, you need a series of periodic cash flows like that shown in the figure...
4 comments:

Linear Interpolation In Excel

›
There are many ways to perform linear interpolation (or extrapolation) in Excel.
5 comments:

Factorial of Positive Non-Integer Values in Excel

›
I'm in the proces of creating a control chart template and needed to calculate the factorial of a non-integer value in Excel.

Array Formulas

›
Here are some tips related to the use of Array Formulas in Excel .
2 comments:

Display Feet and Inches as 5' 8 1/2"

›
When converting metric distances to English units of feet or inches, you'll end up with a decimal value. But, you may want to display th...
13 comments:

Round Price to the Nearest Nickel

›
If you want to avoid pennies, you can round prices to the nearest nickel using the following formula:
2 comments:

Calculating Number of Working Days

›
You can use the NETWORKDAYS() function in Excel to calculate the number of working days (excluding weekends) between and including two dates...
2 comments:

Warning: Excel Performs Negation Before Exponentiation

›
What does –5² equal? –25 or 25? If you said –25, then you probably listened in school when you were told that negation should be performed o...

The BMI Formula

›
I recently created a BMI Chart with Excel and figured I'd list the formulas below, just in case you couldn't find them on the other...
2 comments:

Highlighting Every Other Row Using Conditional Formatting

›
Conditional Formatting (accessed via the Format menu) often makes spreadsheets seem to behave like 'magic' because when a user copi...
3 comments:

Line Break in a Cell Using a Formula

›
The basic way to add a Line Break within a cell is to press Alt+Enter (on a Mac press Ctrl+Option+Return).
39 comments:

Amortization Calculation

›
This article provides a basic explanation of how amortization works. The formula for calculating the periodic payment of a loan is given, al...
1 comment:

Analyze Survey Results with the FREQUENCY Function

›
Surveys that ask you to rate something on a scale of 1-5 or 1-7 or 1-10 are extremely common. If you need to summarize the results of such a...

Calculate Age in Excel

›
There are many ways to calculate a person's age in Excel. However, most formulas are only valid for birthdates after 1/1/1900, because t...
55 comments:

Excel Last Day of Month Formula

›
The quick answer to finding the last day of the month is to use the EOMONTH() function .
3 comments:
›
Home
View web version
Powered by Blogger.