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

    • 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 Budget ...

    • Custom Reports Article

         Tutorial Link Purpose: To create custom reports which can include actuals, budgets, variances and comments for an organization. The report is structured to the user's needs. Reports with a customized Column Format as defined in Define Custom ...

    • Column Formats Article

      Column formats can be defined in the following Setup screens: Define Custom Reports; Define Basic Budgets Entry Forms; and Define Custom Budgets Entry Forms. There are two options to setup Column formats: a) Grid Layout Tab This format supports Copy ...