Excel IF, NESTED IF, AND OR : Sinhala ▶ Excel Advanced Formulas and Functions - Episode 02(Sinhalen)

Описание: ⬇ Download Workfile from here: https://drive.google.com/open?id=15Ya...

The IF function is one of the most popular and useful functions in Excel. You use an IF statement to ask Excel to test a condition and to return one value if the condition is met, and another value if the condition is not met.
In this tutorial, we are going to learn the syntax and common usages of Excel IF function, and then will have a closer look at formula examples that will hopefully prove helpful both to beginners and experienced Excel users.
Excel IF function - syntax and usage
Using the IF function in Excel - formula examples
IF examples for numbers
How to use the IF function with text values
Using Excel IF function with dates
Excel IF statement for blank, non-blank cells


Learn Microsoft Excel and Microsoft Power BI in Sinhala with this group. We will be teaching Excel from Basic to Advance in a very simple form.

Other Important Videos
Excel VLOOKUP Exact Match: Sinhala ▶ Excel Advanced Formulas and Functions - Episode 01(Sinhalen)
   • Excel VLOOKUP Exact Match: Sinhala ▶ Excel...  

Amazing and Simple Data Entry Form Excel: Sinhala ▶ Excel Tips and Tricks - Episode 01 (Sinhalen)
   • Amazing and Simple Data Entry Form Excel: ...  

Excel Top 30 Shortcut Keys : Sinhala ▶ Excel Basics - Episode 06 (Sinhalen)
   • Excel Top 30 Shortcut Keys : Sinhala ▶ Exc...  

Excel Data Validation Controls : Sinhala ▶ Excel Basics - Episode 04(Sinhalen)
   • Excel Data Validation Controls : Sinhala ▶...  

Excel Drop-down list: Sinhala ▶ Excel Basics - Episode 03(Sinhalen)
   • Excel Drop-down list: Sinhala ▶ Excel Basi...  

Excel Progress Circle Chart: Sinhala ▶ Charts and and Data Viz. in Excel - Episode 01(Sinhalen)
   • Excel Progress Circle Chart: Sinhala ▶  Ch...  



excel tutorial
excel basic
excel advanced tutorials
excel tutorial sinhala
excel sinhala
excel vlookup
excel dashboard
excel formulas and functions
excel shortcut keys
excel basic for beginners
excel tricks
power BI tutorials for beginners
power bi tutorial
power bi dashboard
power bi tutorial advance
power bi dax
power query

Also you can connect with me on Below Channels.

FaceBook : https://www.facebook.com/Excel-and-Po...
LinkedIn :   / kasun-manchanayake-fmva™-cba-mos-4756a532  
Web : www.dubaipowerbi.com

We will be covering these areas from our excel and Power BI tutorials series.

My Online Courses

1. The Beginner's Guide to Excel - Excel Basics Tutorial
2. Advanced Excel Formulas and Functions (8 Hours)
3. Analyzing Data with Excel Power Query, Power Pivot and DAX (20 Hours)
4. Excel Data Visualization in Depth (5 Hours)
5. Excel PivotTables in Depth (5 Hours)
6. Analyzing and Visualizing Data with Microsoft Power BI (20 Hours)
7. Excel Master Class
8. Excel Dashbaords Course
8. Financial Reporting with Power BI
9. HR Analytics with Power BI

Text Functions
Logical Functions
Information Functions
Date and Time Functions
Lookup and Reference Functions
Math and Trig Functions
Statistical Functions
Database Functions
Financial Functions
Engineering Functions
Cube Functions
Web Functions
Excel Dashboards

INDEX + MATCH CONDITIONAL FORMATTING CONCATENATE VLOOKUP SUMIF, COUNTIF, AVERAGEIF IF STATEMENTS HLOOKUP XLOOKUP SUM, COUNT, AVERAGE PIVOT CHARTS DATA VALIDATION CONDITIONAL FORMATTING VBA MACRO DASHBOARDS DROPDOWNLIST

#exceltutorialsinhalen #excelvlookup #exceldashboard