Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting
  • Excel sessions – 2013 VS 2010 Excel User tips
  • Calculate above and below me Average
  • IFS (and IFNA) to avoid nested IFs Formulas - combined functions
  • DayName Date and Time
  • Fixed length ID Formulas - combined functions
  • Excel Limits Excel User tips

Category: IFS

IFS (and IFNA) to avoid nested IFs

Posted on March 25, 2018 By ANmar
IFS (and IFNA) to avoid nested IFs

I tend to see more and more the usage of nested IF functions recently

Now, do not get me wrong, IF is great, but come on, are you going to use it for more than 2 conditions? seriously?

Excel 2013 comes with IFS, the perfect alternative to nested IFs

As you can see, takes up to 127 conditions, neat, right?

Read More “IFS (and IFNA) to avoid nested IFs” »

Formulas - combined functions, IFNA, IFS, Logical, Standard functions

Recent Posts

  • Calculate above and below me
  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (83)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (31)
      • AND (5)
      • IF (25)
      • IFERROR (7)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (6)
      • Average (1)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • Looplist – Repeating months using formulas Basic Math
  • Search across sheets in function ADDRESS
  • Sorting with functions only CHOOSE
  • Walking Columns ActiveX controls
  • Show developer tab Excel User tips
  • Extract current (Active) workbook name CELL
  • Cell formats 0.0\% and 0.0%;(0.0%) Format Cells
  • Shapes with dynamic output Excel User tips

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme