Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Excel Limits Excel User tips
  • Tally chart in functions Formulas - combined functions
  • Rotate table using 1 formula ADDRESS
  • Custom fiscal year calendar (CFlex) Basic Math
  • Extract current (Active) workbook name CELL
  • Change Calculator – calculate change in multiple bills/coins Formulas - combined functions
  • Multiple lines in cell using functions CHAR
  • Cuts string of list of items Formulas - combined functions

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

  • Excel Dynamic Drop-Downs that grow with you COUNTA
  • Sorting with functions only CHOOSE
  • Sum of divide – Array formula Array formula
  • Middle name + 1st name Basic Math
  • Multiple lines in cell using functions CHAR
  • Jan8 date format AND

Recent Posts

  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage
  • Jan8 date format

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 (82)
    • 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 (30)
      • AND (5)
      • IF (24)
      • IFERROR (6)
      • 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 (5)
      • 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
  • Middle name + 1st name Basic Math
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting
  • Week number to Month number DATE
  • Searching table in 2 dimensions. Formulas - combined functions
  • Sorting with functions only CHOOSE
  • Count how many times letter found Formulas - combined functions
  • Excel keeps converting all cells to “Date” (or Time) Excel User tips
  • Show developer tab Excel User tips

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme