Use programs to define expressions that would be either ambiguous, difficult to read, or impossible to construct using ranges, conditional functions, and arrays. You can also use programs to conserve memory by defining intermediate steps in large array calculations within the body of the program. The intermediate values are kept in memory only while the program runs rather than until you close the worksheet. Examples of various possibilities for programming follow.

Watch this video to learn more about using programs:

You can create standalone programs:

You can create programs that have only one step without entering the program operator:

You can add programs to a math expression that you evaluate:

You can insert programs when you define a variable or a function:

You can then use the variable or function in your worksheet:

You can define a function in one worksheet for use in other worksheets.