Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Shapes with dynamic output Excel User tips
  • Sheet() and Sheets() Lookup and References
  • Jan8 date format AND
  • Fx to cut long column into two columns Formulas - combined functions
  • DayName Date and Time
  • CHOOSE – tree of decisions CHOOSE
  • Links between two workbooks – dynamically using functions INDIRECT
  • CTRL+Y a mini macro 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

  • Extract Address into table Formulas - combined functions
  • Cells with additional spaces AND
  • iframe in Excel (XLiFrame) ADDRESS
  • Cell formats 0.0\% and 0.0%;(0.0%) Format Cells
  • Excel Dynamic Drop-Downs that grow with you COUNTA
  • Progress bar in pure functions CHAR

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
  • Tally chart in functions Formulas - combined functions
  • Edit directly in cell Excel User tips
  • Cells with additional spaces AND
  • CamelCase to Camel Case CHAR
  • Looplist – Repeating months using formulas Basic Math
  • Expenses calendar, FaCal Basic Math
  • The Excel “&” bug Excel User tips
  • CTRL+Y a mini macro Excel User tips

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme