Archive for December, 2014

Argus Limitation #5: Cannot Print Reports using Reporting Packages

Tenant Reimbursement Detail and Input Assumptions reports are not available for Reporting Packages.

WORKAROUND: Print each individual report for each property.  Do not use Reporting Packages.

Excel Tips: Display the Actual Cell Values When Creating or Editing a Formula

Here’s how to switch between displaying the cell addresses in a formula and the actual values in each cell. Use any method that displays a formula—for example, when the formula of the current cell is visible in the formula bar, or when you’re creating a formula for the first time, or after pressing Ctrl-tilde to display formulas throughout the worksheet. In the formula you want to find out about, select the cell addresses, and press F9. The highlighted addresses are replaced by the values of all the cells referenced in the formula. Press Esc to return to normal display. The screenshot above shows a formula that normally displays the address D12:O12, but when I selected that address and pressed F9, the actual values appeared.