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
Green triangles in Excel
-
- Administrator
- Posts: 78483
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Green triangles in Excel
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.
In many cases, you can safely ignore the green triangles.
Best wishes,
Hans
Hans
-
- Administrator
- Posts: 7209
- Joined: 15 Jan 2010, 22:52
- Location: Middle of England
Re: Green triangles in Excel
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:
You do not have the required permissions to view the files attached to this post.
Leif
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: Green triangles in Excel
Hi Leif,
I know my data/ calculation is correct. I tested it. Still I see that triangles.
Regards,
Bita
I know my data/ calculation is correct. I tested it. Still I see that triangles.
Regards,
Bita
-
- Administrator
- Posts: 7209
- Joined: 15 Jan 2010, 22:52
- Location: Middle of England
Re: Green triangles in Excel
I didn't say your data/ calculation was not correct - I was simply showing you how to check what 'error' Excel is reporting.
Leif
-
- BronzeLounger
- Posts: 1498
- Joined: 01 Mar 2015, 02:03
Re: Green triangles in Excel
Leif,
Thanks for your reponse.
bita
Thanks for your reponse.
bita