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