Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Multiple lines in cell using functions CHAR
  • Sheet() and Sheets() Lookup and References
  • Progress bar in pure functions CHAR
  • Why I ran from =INDIRECT() function Formulas - combined functions
  • Extract Address into table Formulas - combined functions
  • Excel @ before function names in formulas Excel User tips
  • When Excel tells you to go get some life Excel User tips
  • OFFSET+MATCH Formulas - combined functions

Category: Average

Calculate above and below me

Posted on April 9, 2026 By ANmar No Comments on Calculate above and below me
Calculate above and below me

Calculating average of the column in a cell inside that same column Getting average of what is above me and what is below me in my same column in one of the cells DS2 has 1 to use as Average, anything else to get regular number from some calculation … PH2 = IF($DS2=1, IFERROR(AVERAGE(PH$1:PH1,PH3:PH$110),”N/A”), “Other…

Read More “Calculate above and below me” »

Average, IF, IFERROR, Logical, Standard functions, Statistical

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
  • Search across sheets in function ADDRESS
  • Excel sessions – 2013 VS 2010 Excel User tips
  • Cells with additional spaces AND
  • Extract Address into table Formulas - combined functions
  • Highlight dates dynamically AND
  • Limited Ceiling Basic Math
  • BMI Calculator Basic Math
  • IF with AND and IF with OR AND

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme