Bobby

The green triangle does not necessarily mean an error, so "error in the
formula right?" is not correct.

Could be just an inconsistent formula in the region.

If you look at Tools>Options>Error Checking you will see a list of options
that Excel looks at when assigning a green triangle.


Gord Dibben Excel MVP

On Thu, 21 Jul 2005 16:10:21 -0500, Bobby <[email protected]> wrote:

>Hi, and thanks
> in some cells I have a green triangle This means an error in the
>formula right? the formula is in c9 I have
>=sum(b8:c8)/2 in b8 i have 50.46 c8 i have 43.72 and c9 comes out
>with the correct answer 40.79 what gives? There is no error.
>
> Thanks Much
> Bobby