Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Search across sheets in function ADDRESS
  • Fixed length ID Formulas - combined functions
  • Stale values (Scratched functions) Excel User tips
  • The Excel “&” bug Excel User tips
  • 6174 Kaprekar’s constant Basic Math
  • Sort list dynamically (functions) COLUMN
  • Schedule column Basic Math
  • Formula Beautifier Excel User tips

SimpleANBox

Posted on January 21, 2019 By ANmar

This is a financial box, a saving account, a credit, a loan, or any other financial amount that has input and output.

During my time with technology (since 1997) I found myself needing to open a lot of these boxes, to track accounts, or loans, or virtual business partnerships between multiple partnerrs. And this is the core to it.

You basically have startup amount, then you either add, or subtract amount as you go with time.

Like you do when you have a safe, or want to save for some trip, or when you get some money from a relative they asked you to invest it in the market.

SimpleANBox is the spreadsheet that lets you easily follow the flow of amounts you put in or amount you take out.

I usually put this in my OneDrive, then share a link to allow my partner see it or edit it, then start tracking this amount as we change and grow.

Download
Online Excel version
Basic Math, DATE, Date and Time, Formulas - combined functions, IF, IFERROR, Logical, Math and Trig, SUM, TODAY, WEEKDAY, Worksheet Tags:DATE, IF, IFERROR, SUM, TODAY, WEEKDAY

Post navigation

Previous Post: Looplist – Repeating months using formulas
Next Post: Fixed length ID

Related Posts

  • Count how many times letter found Formulas - combined functions
  • Sort list dynamically (functions) COLUMN
  • Sheet() and Sheets() Lookup and References
  • Validation based on another Validation COUNTA
  • Cuts string of list of items Formulas - combined functions
  • IFS (and IFNA) to avoid nested IFs Formulas - combined 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
  • Custom fiscal year calendar (CFlex) Basic Math
  • GoLast to jump to last cell in a column CELL
  • Extract Address into table Formulas - combined functions
  • Cells with additional spaces AND
  • New function IFERROR, finally IFERROR
  • Excel ad from early 90s Non-functions
  • Excel Functions = XL f(x)s XLfxs
  • Paste Special Percentage Excel User tips

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme