Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Blank (isempty) VS “” (null string) Excel User tips
  • Pixel Excel Drawing Format Cells
  • Schedule column Basic Math
  • Zipcode-State search Formulas - combined functions
  • Validation based on another Validation COUNTA
  • CONVERT function CONVERT
  • UDF – Convert Number into text (English and Arabic) User-Defined f(x)s = UDF
  • Extract Address into table 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

  • Workdays – Across months DATE
  • Sum of divide – Array formula Array formula
  • Sort list dynamically (functions) COLUMN
  • Convert 2-column into wide (column-row) table Formulas - combined functions
  • Min Max vehicle Formulas - combined functions
  • When Excel tells you to go get some life Excel User tips

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
  • GoLast to jump to last cell in a column CELL
  • 0% interest promotion Basic Math
  • CamelCase to Camel Case CHAR
  • Week number to Month number DATE
  • Calculate hours between two cells ABS
  • WorksheetName and WorksheetsNo UDFs Lookup and References
  • State Abbr with Index+Match+Validation Data Validation
  • Pixel Excel Drawing Format Cells

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme