Using 'CONCATENATE' function in Excel

The CONCATENATE in Excel function is used to join two or more cells values, text strings or words. One can CONCATENATE upto 255 items altho...

Using 'OR' function in Excel

The 'OR' function is one of the basic logical functions in Excel. It returns either 'TRUE' or 'FALSE' like most lo...

Using 'AND' function in Excel

The AND function is Excel is used to perform logical tests. The power of AND function multiplies when used with 'IF' function. T...

Using 'COUNTIF' function in Excel

The COUNTIF function counts the number of cells within a range meeting the specified criteria. For example, you can count the number of ti...

Using 'COUNT' function in Excel

This tutorial will cover the COUNT function of Excel. This function can be used to count the number of cells, within the specified range, ...

Implementing IF-ELSE logic in Excel

Like any programming language, you can implement IF-ELSE logic in Excel. The only difference if the way it is implemented. Lets consider t...

Using Nested 'IF' function in Excel

If you understand the IF function in Excel then please continue to understand how to use nested IFs. Otherwise please go through the below...

Using 'IF' function in Excel

In Excel you can make use of IF function to test a condition and return the value based on whether the condition was met. The syntax if IF...

VLOOKUP Function in Excel

While working with Excel, quiet often you will feel the need the search a table in excel and get some value from it.  There are few in-b...

HLOOKUP Function in Excel

While working with Excel, quiet often you will feel the need the search a table in excel and get some value from it.  There are few in-bui...