Volatile Functions in Excel
There are some functions that can generate a different result with each recalculation even when none of its arguments changed. Let’s see what the volatile...
Category: Formulas
Excel Formula Exercises 1
I am starting a new series of posts for you to sharpen your skills with Excel formulas. Each post will include 4-5 excel formula exercises...
Extract Text From String With Known Position
You may need to get a part of a text string from within another text string. If you know starting position of the text you...
Hiding Excel Formulas
Sometimes you may not want users to see your formulas for a number of reasons. If that is the case, I have good news for...
Nper Function
Nper Function is used for calculating number of periods for an investment based on periodic, constant payments and constant interest rate.
