How To
Mixing CCH Accounts Production and Excel commands
CCH Accounts Production
Mixing the CCH Accounts Production AP() function and Excel functions
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.
Related documents
CCH Accounts Production/iXBRL essentials training online (10133804)/(10133819)
This document outlines a course on using CCH Accounts Production software, aimed at helping new users efficiently produce statutory accounts. The course includes 1 x 2 hour session and 1 x 3 hour session focusing on practical skills such as setting up accounting periods, importing trial balances, and navigating the software. It is designed for all employees involved in preparing statutory accounts. Training is conducted in an interactive environment called CloudShare, with additional resources available online for further learning and support.
CCH Accounts Production: essentials training online (10133819)
This document outlines a course on using CCH Accounts Production software, aimed at helping new users efficiently produce statutory accounts. The course includes two 2-hour sessions focusing on practical skills such as setting up accounting periods, importing trial balances, and navigating the software. It is designed for all employees involved in preparing statutory accounts. Training is conducted in an interactive environment called CloudShare, with additional resources available online for further learning and support.
CCH Accounts Production 2026.3 Hotfix: Release Notes
Release Notes for CCH Accounts Production 2026.3 Hotfix
CCH Accounts Production 2026.3: Release Notes
Release Notes for CCH Accounts Production 2026.3
CCH Accounts Production 2026.2: Release Notes
Release Notes for CCH Accounts Production 2026.2