0
When a formula in Excel is incorrect is there a green triangle?
Wiki User
∙ 9y ago
Not necessarily. Sometimes there can be an error and there will be no green triangle. Other times there is a green triangle, but the formula is not necessarily wrong. It is there to give you a warning that there may be a problem, like if it thinks the range is not large enough. Sometimes you can choose to ignore the error, because the formula is doing what you actually want it to do. A formula may have an error of other kinds, that will not be picked up as warnings.
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
What is a green triangle in Excel?
it means an error in the cell formula. http://www.bestjobsmagazine.com/ -- click to find some jobs
When a formula fails to pass one of the rules and background formula checking is enabled excel displays a small what in the upper left corner of the cell assigned the formula?
It contains some information regarding the error and help you to solve the error. For example if you divide by 0 and will get a #DIV/0 message you'll see a green mark on the upper right corner to help you notice this cell contains an error. When you'll put the cursor on it, a small menu will open with actions you can do, for example, get help on this, edit the function, ignore and more.. For more excel tips go to excel-tip.com
What does a green arrow in the corner of an Excel cell mean?
A green arrow in the corner of an excel cell means that excel suspects soemthing may be wrong with the formula in a particular cell.
Indicates a formula fails to pass a rule?
small green triangle
A cell that is outlined in green and has data typed in it is the in Excel?
A cell that is outlined in green is normally the second cell referenced in a formula, when you start to edit the formula. It does not have to have any data in it. You could be referring to the active cell, but that is not outlined in green and again it does not have to have anything typed into it.
When writing a formula by pointing how do you end the formula in Excel?
You could press the Enter key, but if doing it exclusively with the mouse, you could click on the green tick at the left end of the Formula Bar and enter the formula that way.
Where is the enter box in Excel?
The Enter box is the green tick that appears beside the formula bar when you are entering or editing a cell.
In Excel the cell surrounded by a green border is called?
You are referring to the active cell. However, it is possible to change the colour scheme. Also, when constructing a formula, different cells that are referenced are highlighted in different colours, including green. So a cell in a formula can be enclosed in a green border.
When an error occurs in a formula in a cell Excel displays the button next to the cell and identifies the cell with the error by placing a green triangle in the upper left of the cell?
That is correct.That is correct.That is correct.That is correct.That is correct.That is correct.That is correct.That is correct.That is correct.That is correct.That is correct.
How do you enter in Excel?
If you are typing something in, you can press the Enter key or press the Tab key or you could click on the green tick beside the formula bar.
If you edit a cell in a calculated column so it is no longer consistent with the other formulas what appears in the upper left corner of the cell?
A green triangle will appear in the upper left corner (at least it will in Excel 2007).
How do i add formula for excel if an answer in box is over 100 percent eg if under 100 percent box is red if over 100 percent box is green?
Use conditional formatting
