Re: Formula errors

If you select one of those cells that has the green flag you'll see an
Error
Alert button appear adjacent to the cell. If you click that button the
menu
that pops open will tell you what the error is - In this case you have a
formula that refers to one or more cells which do not contain values.
Technically that's a no-no in a worksheet:-) But you can dismiss the error
if you wish from the choices in the button's menu.

If you go to Excel> Preferences - Error Checking you can choose what type
of
errors get flagged in that manor.

HTH |:>) 
Bob Jones 
[MVP] Office:Mac


On 6/26/08 1:16 PM, in article 59b52711.-1@[EMAIL PROTECTED]
"Druce@[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?