Course Content

How to Work with Menu Bar

5m 39s

How to use LearnVern

3m 20s

What is Quick Access Toolbar and How to Work with it

6m 33s

How to Work with Formula Bar

2m 35s

What is Status Bar and How to Work With it

5m 33s

How to Navigate within Sheet and Workbook

3m

How to use Shortcuts

4m 3s

What is Format Painter and How to work with it

2m 25s

How to Enter Data in MS Excel

4m 58s

How to Use Autofill Functionality

5m 32s

How to Enter Date-Time

6m 11s

How to Use Undo-Redo

5m 17s

How to Work With Comments in MS Excel

3m 29s

How to Save Workbook in MS Excel

4m 16s

How to Create Formula in MS Excel

7m 40s

How to Copy Formula in MS Excel

3m 31s

How to Use Till Date Profit Formula

3m 37s

How to Work with Percentage Change Calculation

5m 22s

How to Use Absolute Value

6m

How to Use Sum Average

5m 28s

Which are the Common Functions

7m 39s

How to Format the Fonts

3m 41s

How to Adjust Rows and Columns

3m 57s

How to Use Alignment

7m 3s

How to Format the Borders

2m 56s

How to Format Numbers

3m 52s

How to Format Date-Time

9m

How to Use Conditional Formatting

9m 6s

How to Format Tables

9m 1s

How to Format Shapes

6m 49s

How to Resize Row & Column

7m 2s

How to Hide-Unhide Row & Column

5m 23s

How to Copy ,Move & Insert Data

5m 28s

How to Find and Replace Data

6m 32s

How to Print

8m 33s

What is Page Break Preview & How to Set Page

5m 21s

How to Set Page

4m 57s

How to create Charts

7m 10s

Which are the different types of Chart

5m 37s

How to Format Charts

6m 31s

Which are the Chart Elements

7m 42s

How to Use Spark lines

7m 54s

How to Freeze-Unfreeze the Row & Column

7m 26s

How to Split the Sheet

6m 50s

How to Use Outline

6m 59s

How to Manage Multiple Workbook

6m 37s

How to Use Rename Insert hide unhide sheets

4m 38s

How to Copy & Delete Sheets

6m 30s

How to Use Formula

9m 4s

How to Edit Links

9m 12s

How to Protect Sheet

4m 52s

How to Secure Workbook

6m 7s

How to Set Password in Workbook

2m 19s

How to Share Workbook

3m 9s

How to Track Changes

5m 34s

How to Perform Sorting

6m 35s

How to do Subtotals

7m 26s

How to Perform Filter

5m 31s

How to Spilt Data

4m 20s

How to Use Flash Fill

3m 35s

How to Remove Duplicate Data

2m 34s

How to Validate Data

6m 51s

How to Create Pivot Table in MS Excel

11m 6s

How to Manipulate Pivot Table

8m 19s

How to Add Slicers

4m 36s

How to Perform Grouping of Pivot Table

4m 39s

What is Macro And How to Use It

7m 25s

Assignment Q-1

1m 10s

Assignment Q-2

21s

Assignment Q-3

34s

Assignment Q-4

50s

Assignment Q-5

48s

Assignment Q-6

37s

Assignment Q-7

47s

Assignment Q-8

45s

Assignment Q-9

37s

Assignment Q-10

32s

What is IF Condition and How to Use it

MS Excel in Bangla If condition VLOOKUP

Enroll Now For Free
Previous Next
Discussion
Previous Discussion Next
Previous
Next

Course Content

How to Work with Menu Bar

5m 39s

How to use LearnVern

3m 20s

What is Quick Access Toolbar and How to Work with it

6m 33s

How to Work with Formula Bar

2m 35s

What is Status Bar and How to Work With it

5m 33s

How to Navigate within Sheet and Workbook

3m

How to use Shortcuts

4m 3s

What is Format Painter and How to work with it

2m 25s

How to Enter Data in MS Excel

4m 58s

How to Use Autofill Functionality

5m 32s

How to Enter Date-Time

6m 11s

How to Use Undo-Redo

5m 17s

How to Work With Comments in MS Excel

3m 29s

How to Save Workbook in MS Excel

4m 16s

How to Create Formula in MS Excel

7m 40s

How to Copy Formula in MS Excel

3m 31s

How to Use Till Date Profit Formula

3m 37s

How to Work with Percentage Change Calculation

5m 22s

How to Use Absolute Value

6m

How to Use Sum Average

5m 28s

Which are the Common Functions

7m 39s

How to Format the Fonts

3m 41s

How to Adjust Rows and Columns

3m 57s

How to Use Alignment

7m 3s

How to Format the Borders

2m 56s

How to Format Numbers

3m 52s

How to Format Date-Time

9m

How to Use Conditional Formatting

9m 6s

How to Format Tables

9m 1s

How to Format Shapes

6m 49s

How to Resize Row & Column

7m 2s

How to Hide-Unhide Row & Column

5m 23s

How to Copy ,Move & Insert Data

5m 28s

How to Find and Replace Data

6m 32s

How to Print

8m 33s

What is Page Break Preview & How to Set Page

5m 21s

How to Set Page

4m 57s

How to create Charts

7m 10s

Which are the different types of Chart

5m 37s

How to Format Charts

6m 31s

Which are the Chart Elements

7m 42s

How to Use Spark lines

7m 54s

How to Freeze-Unfreeze the Row & Column

7m 26s

How to Split the Sheet

6m 50s

How to Use Outline

6m 59s

How to Manage Multiple Workbook

6m 37s

How to Use Rename Insert hide unhide sheets

4m 38s

How to Copy & Delete Sheets

6m 30s

How to Use Formula

9m 4s

How to Edit Links

9m 12s

How to Protect Sheet

4m 52s

How to Secure Workbook

6m 7s

How to Set Password in Workbook

2m 19s

How to Share Workbook

3m 9s

How to Track Changes

5m 34s

How to Perform Sorting

6m 35s

How to do Subtotals

7m 26s

How to Perform Filter

5m 31s

How to Spilt Data

4m 20s

How to Use Flash Fill

3m 35s

How to Remove Duplicate Data

2m 34s

How to Validate Data

6m 51s

How to Create Pivot Table in MS Excel

11m 6s

How to Manipulate Pivot Table

8m 19s

How to Add Slicers

4m 36s

How to Perform Grouping of Pivot Table

4m 39s

What is Macro And How to Use It

7m 25s

Assignment Q-1

1m 10s

Assignment Q-2

21s

Assignment Q-3

34s

Assignment Q-4

50s

Assignment Q-5

48s

Assignment Q-6

37s

Assignment Q-7

47s

Assignment Q-8

45s

Assignment Q-9

37s

Assignment Q-10

32s

FAQs

The IF function performs a logical test and returns two values: one for TRUE and another for FALSE. =IF(A1>70,"Pass","Fail"), for example, to "pass" scores above 70. IF functions can be nested to test several conditions.

Excel's IF Function In Excel, the IF function makes a logical comparison between two values. The IF function returns either TRUE or FALSE as a result. We can, for instance, see if the value in cell B2 is higher than the value in cell A2. If this is the case, the result is TRUE; otherwise, the result is FALSE.

The IF statement checks an expression to see if it meets a condition and then returns a value based on the result. For example, if the condition is found to be true, it returns one predetermined value; if the statement is found to be false, it returns a different prepared value.

The if statement is used to check a condition, and if the condition is true, a block of statements (called the if-block) is executed; otherwise, another block of statements is executed (called the else-block). The else clause is not required.

Syntax. If a condition is true, the IF function returns one value; if it is false, it returns another one. =IF(A2>B2,"Over Budget","OK"), for example.

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere