Green triangles in Excel

BittenApple
BronzeLounger
Posts: 1427
Joined: 01 Mar 2015, 02:03

Green triangles in Excel

Post by BittenApple »

Hello team,

Sometime, when I pull the formula down the columns, green triangles appear on the corner of cells; that means inconsistent calculation, while I test the result of calculation and it is all correct.

Why do they appear while the calculation is correct?

Regards,

Bita :thankyou: :thankyou: :thankyou: :thankyou: :thankyou: :thankyou: :thankyou:

User avatar
HansV
Administrator
Posts: 72233
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Green triangles in Excel

Post by HansV »

It could also mean that the calculation is different from the calculations in neighboring cells.
In many cases, you can safely ignore the green triangles.
Regards,
Hans

User avatar
Leif
Administrator
Posts: 7170
Joined: 16 Jan 2010, 08:21
Location: UK/France

Re: Green triangles in Excel

Post by Leif »

BittenApple wrote:
22 Jun 2021, 03:30
Why do they appear while the calculation is correct?
If you select the cell and then hover your mouse pointer to the left of the green triangle, you should see a drop-down appear, plus a 'tool tip' explaining what the 'error' is. For example:
    
x.jpg
You do not have the required permissions to view the files attached to this post.
Leif.

BittenApple
BronzeLounger
Posts: 1427
Joined: 01 Mar 2015, 02:03

Re: Green triangles in Excel

Post by BittenApple »

Hi Leif,
I know my data/ calculation is correct. I tested it. Still I see that triangles.
Regards,
Bita

User avatar
Leif
Administrator
Posts: 7170
Joined: 16 Jan 2010, 08:21
Location: UK/France

Re: Green triangles in Excel

Post by Leif »

I didn't say your data/ calculation was not correct - I was simply showing you how to check what 'error' Excel is reporting.
Leif.

BittenApple
BronzeLounger
Posts: 1427
Joined: 01 Mar 2015, 02:03

Re: Green triangles in Excel

Post by BittenApple »

Leif,
Thanks for your reponse.
bita