## 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:

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

## Common Excel Questions in an interview: How to divide a single sheet into multiple windows using Freeze Panes/Split?

How to divide a single sheet into multiple windows using Freeze Panes/Split? In Excel, you can divide a single sheet into multiple windows by Freeze Panes or Split. Suppose you have a spreadsheet with 2,000 lines, where the heading is in line 1, what should we do so that we can keep the heading on … 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

## How to calculate percentage in Excel

How to calculate percentage in Excel? The different percentage calculation types are: [vtftable ];;;E.G.;nn;Percentage of a Number;;;What is 25% of 50?;nn;Percentage as a Proportion;;;E.g. If a flight have to fly 1000 KM from it’s origin, and now it flied 780KM. How many % of journey have it completed?;nn;Percentage Change;;;E.G. If you got a pay raise … Read more

## Looking at the View tab in Excel | Excel for Absolute Beginners

In This Walkthrough We: Take a look at the View tab in Ms Excel Aimed At: Who know how to use Excel and want to learn View functions in Excel Prerequisites: Please Read Exploring The Home Tab | Excel for Absolute Beginners Exploring the Home tab (Part 2) | Excel for Absolute Beginners Setting the … 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 sort and filter data in Excel?

In this walkthrough, we will illustrate how to sort and filter data in Excel. Followed by: Take an in-depth look at Excel Filter Option & Copying Excel Cells through the Fill handle Aimed At: People who know nothing about Excel and want to know the Basics Prerequisites: Please Read : Exploring The Home Tab | … Read more

## Top 5 most useful Excel functions – Maths

Excel offers a wide range of functions which you can in any kind of worksheet. Excel formulas work on Strings as well as Numbers. Lets take a look at some of very useful Mathematical functions in Excel. In this walkthrough, we will learn the 5 most useful mathematical Excel functions – how to get the … 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