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

Top 5 most useful String functions in Excel

In This Walkthrough We Take a look at some of the most useful text/string functions in Excel Aimed At: Who know basic Excel and want to learn about Excel text functions Prerequisites: Please read: Exploring The Home Tab | Excel for Absolute Beginners Exploring the Home tab (Part 2) | Excel for Absolute Beginners Top … Read more

How to insert pictures, shapes or Text box and make Your Excel Workbook look more Professional

In This Walkthrough We will learn to: Insert Pictures, Shapes and Text Boxes in Excel to make your Workbook look more Professional Aimed At: People who are still pretty much learning Excel and want to make their workbook look more formal Prerequisites: Please Read Exploring The Home Tab | Excel for Absolute Beginners Exploring the … Read more

How to set the layout, page size, print area of an Excel document

In This Walkthrough We will learn how to: Set the layout, page size of the page and also take a look at the Print Option and print area of a document in Excel Aimed At: People who know basic functions in Excel and want to learn about Print options in Excel Prerequisites: Please Read: Exploring … Read more