Nested IF Functions in Excel
Channel:
Subscribers:
4,790
Published on ● Video Link: https://www.youtube.com/watch?v=EtLsHyMvh-A
0In this video we look at IF functions, one of my favourites and most useful functions i've learned.
The IF function has three sections inside the brackets, which are separated by commas:
The comparison statement
The value to use when the comparison is true
The value to use when the comparison is false
=IF(Comparison,true value,false value)
Nested IF
=IF(comparison1, true value, IF(comparision2, true value, both false value))
=IF(A1=75,“Pass”,IF(A1=50,”Fail”,”ReTake”)
Music form Bensound
Other Videos By Tech Head Online
| 2020-03-01 | Flat File & Relational Databases |
| 2020-03-01 | Importing from an External Data Source |
| 2020-02-17 | Database Basics in Microsoft Access |
| 2020-02-17 | Charts and Graphs in Excel |
| 2020-02-17 | Conditional Formatting in Excel |
| 2020-02-17 | Data Validation in Excel |
| 2020-02-17 | Sorting and Filtering in Excel |
| 2020-02-16 | Printing Worksheets in Excel |
| 2020-02-16 | Manipulating Text in Excel LEFT, RIGHT, MID & CONCATENATE |
| 2020-02-13 | IF Functions for IGCSE ICT |
| 2020-02-13 | Nested IF Functions in Excel |
| 2020-02-13 | COUNT functions in Excel |
| 2020-02-13 | VLookup & HLookup in Excel 365 |
| 2020-02-11 | Formatting a Spreadsheet in Microsoft Excel |
| 2020-02-11 | Microsoft Excel Basics |
| 2020-02-09 | Spell check and Replace in Word 365 |
| 2020-02-09 | Hanging Paragraphs in Word 365 |
| 2020-02-09 | Inserting and Editing Images into Microsoft Word 365 |
| 2020-02-09 | Creating Tables in Microsoft Word 365 |
| 2020-02-09 | Microsoft Word Creating Columns and Page Breaks |
| 2020-02-09 | Microsoft Word Mail Merge #2 Displaying Field Codes |