Triangle

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

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

Thanks Gord
I knew it wasn't wrong but it puzzled me. Theres so much to Excel.
Bob

On Thu, 21 Jul 2005 15:14:58 -0700, Gord Dibben <gorddibbATshawDOTca>
wrote:

>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

Thanks for the feedback.

I've always thought the feature should be called "anomaly reporting".


Gord

On Thu, 21 Jul 2005 18:45:04 -0500, Bobby <[email protected]> wrote:

>Thanks Gord
> I knew it wasn't wrong but it puzzled me. Theres so much to Excel.
> Bob
>
>On Thu, 21 Jul 2005 15:14:58 -0700, Gord Dibben <gorddibbATshawDOTca>
>wrote:
>
>>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