Cell Math Functions Article

Cell Math Functions Article

Certain screens within the program has been setup with the ability to do basic math calculations within the cell.  The math functions are:

- Addition ("+");

- Subtraction ("-");

- Multiplication ("*"); and

- Division ("/).


The below example uses the functionality embedded in the the Basic Budget Entry screen.




 As above, place your curser in the cell that you would like to do a calculation and enter the calculation.  In this example, we are dividing 50 by 2.

Then "Enter" to activate the calculation.  Please note below that the answer of 25 is now in the Jan cell.


 

Please note that the formula (50/2) is not saved/retained - only the final answer (25) is saved/retained in the cell.

    • Related Articles

    • Lookup Functions - Financial & Variables Video

      Click the brackets icon [  ] in the lower right of the video to expand to full screen,  hit escape to return to this page
    • Account Details - Row over Row Math Operators Video

      click the brackets icon [  ] in the lower right of the video to expand to full screen,  hit escape to return to this page
    • Basic Budget Entry Article

          Tutorial Link   Basic Budget Entry  is used for entering and viewing budgets within two tabs:  Dashboard  Account Details  Other entry and viewing screen options are the  Budgeting Dashboard , and the Custom Budget Entry .  The Dashboard tab ...
    • Manage Global Variables Article

      Global Variables are setup to store statistical (nonfinancial and non-system based financial) data and are accessed through Lookup.  Please see the related article How Can I Use Global Variables?  Print, Export to Excel, Print to PDF, Auto-size ...
    • Custom Budget Entry Article

         Tutorial Link Custom Budget Entry is used for entering and viewing budgets.   As discussed in the Define Custom Budgets Entry Forms, all of the columns can be user defined. Custom Budget Entry has two tabs: Dashboard and Account Details. Other ...