Allos formulas Overview
When using Excel formulas to cross-reference information, obtain results and build reports, it is necessary:
- Have the necessary data in Excel;
- Use standard Excel formulas to obtain the desired results.
With Allos, the data remains in the Database and the formulas, although they work like those in Excel, are tailored to the needs of each company.
Allos formulas use exactly the same configuration as Excel formulas. In case you want the Allos formula to be fixed in a cell, row or column, the special character "$" (F4) is also used. This way the user can, with the same formula, fill a report or an entire table.
In addition, being identical in operation to other Excel formulas, we can combine several in the same cell, using Excel's validation mechanisms. For example, the formula "=SE" ("IF" in English) can be used as an auxiliary formula to avoid cells with the value zero, #N/A or #VALOR, if the Allos formula does not bring results.
To check what each of the formulas is calculating, we can select the formula symbol, fxjust like in Excel.
In summary, the Allos formulas are created according to the specific needs of each company, but as they work like Excel formulas, those who know how to use Excel, know how to use Allos.
In following articles, we will analyse in detail the different types of Allos formulas, as well as the simple, fast and autonomous way in which each user can create an Allos formula, without the need to know programming.
Follow us on Linkedin