In article <59b52711.-1@[EMAIL PROTECTED]
>,
Druce@[EMAIL PROTECTED]
wrote:
> Version: 2004
> Operating System: Mac OS X 10.4 (Tiger)
> Processor: intel
>
> We have several invoices that are showing errors (little green triangle
in
> top right corner of cell) for cells that have no numerical entered. Why
is
> that? If I enter zero in A1 and B1 and D1 then my formula for
E1=(A1*B1*D1)
> works. But, if no number is in there I get the error.
>
> What am I doing wrong?
strictly speaking, they are 'warnings', not 'errors'
they show up for things like 'refers t empty cell', 'formula differs
from formulas in surrounding cells' etc.
you can vary what warnings get shown in the preferences.
--
Barry Wainwright
Microsoft MVP
|
