Category: Formulas

Excel Tip: Excel Wildcard Characters

Are you looking for certain items that share last 3 characters? Are you not certain that the name you are searching for is Anna or...

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 Text Functions

  There are a total of 24 functions that are categorized as excel text functions. Though we are all sure that all of them are...

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...