Tagged: Formulas

Excel Date Functions

As we all know by now, there are several functions in excel for handling date values. But they don’t seem much useful at first sight....

IF AND OR Function Combinations

Do you need to use a logical condition in your formulas? Do you need functions like between but can’t find it? This post will show...

HLOOKUP Function

Do you need to fetch certain values from a list searching horizontally? Than HLOOKUP function is for you.

Excel Formula Errors

When dealing with formulas you will get error messages time to time. They may seem similar to you at first glance. But actually every formula...

Watch Window

Are you having difficulty in keeping track of changes in certain cells in your workbooks while you are editing other areas? Constantly turning back perhaps?...

Formula Arrows

When there is too much stuff in your workbook and you start to loose which formula uses which cells, formula arrows will set you into...