Philosophaie
Active Member
- Joined
- Mar 5, 2010
- Messages
- 256
What is the Green Triangle in top left corner for. Does it mean it is not formatted correctly?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Green Triangle in top left corner
- Thread starter Philosophaie
- Start date
Excel Facts
Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Steve Saunders
New Member
- Joined
- Jun 18, 2023
- Messages
- 12
- Office Version
- 365
- Platform
- Windows
It means that there is a potential problem (note the word potential) with a formula. You may want to check for:
Invalid data types
Inconsistent formula
Leading zeros (Number stored as text)
Usually it appears for me when there is an inconsistent formula.
Invalid data types
Inconsistent formula
Leading zeros (Number stored as text)
Usually it appears for me when there is an inconsistent formula.
Upvote
0
MARK858
MrExcel MVP
- Joined
- Nov 12, 2010
- Messages
- 16,844
- Office Version
- 365
- Platform
- Windows
- Mobile
It'll tell you what it thinks the issue is if you click on the triangle (it'll also give you the option to ignore the error which will remove the triangle, if you have more than 1 cell in a continuous range, then select the range from the top left cell to the bottom right cell, click on the triangle on the first cell, click ignore error and it will remove all the triangles in the range)
Upvote
0
Similar threads
- Question
