[ Home ] [ FAQ ] [ Web Pages ] [ Other Sites ]

Using Lotus 123

One major difference between Excel and Lotus 123 is in the use of named ranges in formulas. If you give Excel a formula like =Name1+Name2, it will choose a single value from each range and add the values. Lotus does not have this feature, and will simply produce an error.

This causes problems in the Appdisc4 and Savings assignments from Lesson 2. For these assignments, Lotus users should substitute regular formulas in the places where names cause an error.

NOTE: This problem does not affect things when adding all of the numbers in a range. To get the total of all numbers in the range Name1 and the range Name2, we could use the Lotus formula @SUM(Name1,Name2) or the Excel formula =SUM(Name1,Name2).