Table of contents
No headers

Formulae

Last modified
Table of contents
No headers
Topics
  • The spreadsheet used for editing formats supports standard MS Excel functions, for example =sum(), =average(), =if() etc. It also supports an additional function for the extraction of data from the Accounts Production database, =AP(…), where … is the formula to execute. The formula within the AP() function currently follows the syntax of the formula used in VAP.
  • The AP() function can be mixed with Excel functions. An example is the following: ="Page "&IF(AP("PageTitleN,pagesched"),AP("pageend,pagesched"), AP("lastnotepage")) The parts of this formula are as follows : Part of formula Meaning "Page "& The Excel syntax for the text "Page", and an ampersand to join it to another piece of text IF(..) The Excel IF() function, e.g. =IF(A1>A2,"A1 is bigger!","A1 is not bigger!"). See the documentation on Excel. (Note that you can also do an IF test inside an AP() command but this uses a different syntax.) AP("PageTitleN,pagesched") This is an AP function to check whether the Print Condition for page pagesched is true. AP("pageend,pagesched"), AP("lastnotepage") AP commands to pick up the last page number of page pagesched and the last note page number. So putting it all together, this formula shows "Page xxx" where xxx is the last page number of page pagesched if its print condition is true, otherwise xxx is the last page number of the notes.
  • There are several related commands used to list accounts and their balances: RangeDef lists the account descriptions RangeCode lists the account balances RangeDefCode lists account codes and descriptions, e.g. "0010 Sale of goods". These commands are generally used together. For instance, column B might use a RangeDef command to list the account descriptions, while column C lists the current year balances using a RangeCode command and column D lists last year's balances using another RangeCode command.
  • The RangeDif command is used in variance analysis to show the difference between two periods. It has similar parameters to the RangeDef command. The RangeDif command is generally used with the RangeDef and RangeCode commands. For instance, column B might use a RangeDef command to list the account descriptions, while column C lists the current year balances using a RangeCode command, column D lists last year's balances using another RangeCode command and column E shows the differences between current year and last year. The Dif command is used for adding totals for the rows produced by the RangeDif command.
Page statistics
298 view(s) and 1 edit(s)
Social share
Share this page?

Tags

This page has no custom tags.
CCH Personal Tax

Comments

Attachments

 

 | Cookie Policy | Copyright | Privacy Policy Terms of Use | Contact Us |