Why Weeknum Function Returns Wrong Value ?
This year WEEKNUM Function returns wrong value if you are using it as usual. Because Excel considers the week containing 1st of January as week...
Tagged: excel formulas
Evaluate Formula
Evaluate formula tool helps you figure out what is wrong with your formula. When you are confused about a formula in a worksheet, or is...
Editing Multiple Formulas
Here is a very useful tip about editing multiple formulas at once. This one will save you a lot of time and effort whenever you...
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...
Updating Single Column Formulas
While working in manual calculation mode, you may need to test your formulas occasionally. When this happens, updating single column formulas instead of whole worksheet...
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...
