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