Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Fixed length ID Formulas - combined functions
  • MID + SEARCH to convert cell to rows MID
  • Cuts string of list of items Formulas - combined functions
  • Get 3rd Wednesday of month Basic Math
  • Pixel Excel Drawing Format Cells
  • Links between two workbooks – dynamically using functions INDIRECT
  • CTRL+Y a mini macro Excel User tips
  • GoLast to jump to last cell in a column CELL

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

  • Custom fiscal year calendar (CFlex) Basic Math
  • Convert cell into textbox Excel User tips
  • Calculate hours between two cells ABS
  • Rotate table using 1 formula ADDRESS
  • Highlight dates dynamically AND
  • Excel Limits Excel User tips

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
  • Multiple Dual-Validations COUNTA
  • Cell formats 0.0\% and 0.0%;(0.0%) Format Cells
  • Limited Ceiling Basic Math
  • Calculate hours between two cells ABS
  • Blank (isempty) VS “” (null string) Excel User tips
  • Custom fiscal year calendar (CFlex) Basic Math
  • Excel ad from early 90s Non-functions

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme