Excel

How to replace words in excel? Substitute or replace in excel?

How to replace words in excel

How to replace words in excel? You can use two different functions – substitute and replace. Difference between substitute and replace are shown from the following table. SUBSTITUTE function in excel The substitute function in excel is to replace a text within a cell by a new text Syntax SUBSTITUTE(text,old_text_new_text,[Instance_num]) Argument Argument Description text The … Read more

Getpivotdata – an easier and better way to reference a pivot table in Excel

From my other blog I have illustrated how to create a pivot table. How to read information from a pivot table Now I am going to mention how to refer information from a pivot table. There are two ways to do the job refer to the corresponding cells  (e.g. = a10) using the “GetPivotData” function … Read more

Difference between all 5 count functions (COUNT, COUNTA, COUNTIF, COUNTIFS and COUNTBLANK) in Excel.

Excel Data for Count, CountIF, CountIFS, CountA and CoubtBlank Function

What is the difference between COUNT, COUNTA, COUNTIF, COUNTIFS and COUNTBLANK in Ms-Excel? Suppose we have a table like this.   Different type of count functions The following table illustrated the differences between each function: Usage Count Count number of cells that have numbers or values CountA count any cell value containing numbers, text, logical values, … Read more

How to use if function with multiple conditions and outcomes in Excel

Excel If Statement with multiple condition

This paragraph is original in English. From my last blog, we have introduced the if function in Excel where following is the syntax: Syntax: if function with multiple conditions and outcomes What if we have multiple conditions? Can we use the if function with multiple conditions? The answer is “Yes”. There are two ways to … Read more

Excel Tutorial: How to write an if statement in excel

How to write an if statement in excel?

The IF function in Excel is one of the most popular conditional formula functions, and it allows you to make logical comparisons between a value and what you expect.

Syntax:

[vtftable cols=”{0}0:fff2cc;{/}”]
=if(Condition , Result when matched, result when not matched);nn;
[/vtftable]

For Example:

If Function in Excel

Meaning:

If A2 is less than 10, (exclude 10), then the value for B2 is “<10”, else the value for B2 is “>=10”.

As now A2 is nothing, in Excel, it will be considered as 0. Therefore, the result for B2 is “<10”.

Read more

Top Resources for Intermediate and Advanced Concepts | Excel for Absolute Beginners

After covering the absolute Beginner Series on Ms Excel, We now present you the most useful of the resources. Please go through all of the tutorials again to make sure you didn’t miss anything. We Covered: Past Tutorials: 5 Things That You Should know About Excel | Excel For Absolute Beginners 5 Things That You … Read more