CFOG's PIP, September 1987, Volume 5 No. 11, Whole No. 59, page 2

Nested SuperCalc "if' Tests

by Benjamin H. Cohen

SuperCalc2's "IF" test can be nested to save a lot of work. On one spreadsheet, I used it to make the description entries. This is an account with three types of entries: interest, deposits, and withdrawals. The deposits are always more that $100, and the interest is always less. I set up a spreadsheet to keep track of the account as follows:

Column Description