Excel Logical Functions:

Explained with Examples.



50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates

  • AND: AND is a Logical Function. AND Function in Excel tests two or more conditions to see if they are all true.It returns TRUE if all conditions are TRUE, returns FALSE if any of the conditions is FALSE.
  • IFERROR: IFERROR is a Logical Function. IFERROR Function in Excel check a value and it returns the value if there is no error or else it returns the specified value_if error
  • IF: IF is a Logical Function. IF Function in Excel helps us to check a condition, it returns one value if a specified condition is TRUE, or another value if the condtion is FALSE

Related pages

how to use sumif formula in excel 2010instr function excelbest excel vba bookhow to protect excel sheetexcel formula to calculate difference between two dateswhat is hlookup in excel used forcreate macro for excelvbscript in excelrange vba variablecell color in vbahow to find duplicate entries in excel 2007excel vba remove duplicateshow to learn macros in excelexcel vba close fileexcel 2007 macrosgoto statement vbaexcel macros 2007microsoft office meeting minutes templatevba isnumericleft in excel vbaexcel macro tablefind password excel protected sheethow to eliminate duplicate records in excelexcel vb programmingaverage function in excel 2013access vba do while loopsimple example of vlookup in excelvba delete rows based on cell valuehow to create excel worksheetif and isblank excel formulaprofessional excel development ebookautofit in excelvba activeworksheetconcatenation in excellookup function on excelinterview questions for programmers and answersexcel vba delete columnsusing lookup in excelcombobox userformsql basics commandshow to delete duplicate records in excelnested loops vbaformula to calculate range in excelhow to delete hidden rows in excelplot chart in excelvlookup example 2010vlookup lock table arrayvba delete entire rowcase syntax vbaexcel dashboard tutorialqlikview introduction pptexcel function iserrorddl and dml commands pdfexcel construction schedule templatecolumns vbaexcel consolidate data from multiple sheetspivot table vba codetrim excel functionhow to prepare checklist in excellooping in vbaexcel vba sort rangelookup in excel 2007 with exampleexcel vba inputbox cancelextract hyperlink from excelhyperlink function in exceluser input in vbavba print commandrecordset in vba excelwhere to find pivot table in excelthissheet vbaloop excel macroexcel creating macros