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
 

======================================================================
 
----------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft Works for the Macintosh, versions 4.0, 4.0a, 4.0b
----------------------------------------------------------------------
 
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.