Microsoft KB Archive/135343

Mac Works 4.0 DB Error: “There is a flawed cell representation”

PSS ID Number: Q135343 Article last modified on 10-22-1998

4.00

MACINTOSH

=
=========================================================

= SYMPTOMS =

When you type a formula into a database, you receive the following error message:

There is a flawed cell representation.

= CAUSE =

You cannot type a range into a Database formula.

For example, the formula =SUM(Field1:Field5) causes the error message.

= RESOLUTION =

To avoid the error, you must use one of the following methods to retype the formula.

Method 1
Type the following:

=SUM(Field1,Field2,Field3,Field4,Field5)

-or-

Method 2
Type the following

=SUM(Field1+Field2+Field3+Field4+Field5)

If you need to use a cell range in the formula, use the spreadsheet portion of Works instead of the database. The spreadsheet supports the use of cell ranges and also allows for a higher degree of complexity in the formulas.

= MORE INFORMATION =

You can also receive this error message if one of the Field names is misspelled or if there is a “+” or a “,” missing between two field names.

For more information about typing formulas into a Works 4.0 database, see your “Microsoft Works User’s Guide”.

KBCategory: kbusage kberrmsg kbprb KBSubcategory: mwksdb mksss macworkskb

Additional reference words: 4.00 mac m_works function db ss equation

=
========================================================= Version : 4.00 Platform : MACINTOSH ============================================================================= Copyright Microsoft Corporation 1998.