| You may occasionally come across errors when using | | | | evaluate button and inspecting the formula until the |
| formulas. If you do not know what the problem is, | | | | whole thing is solved; note any errors that happen to |
| then you may need to evaluate the formula. By doing | | | | occur. |
| this you will quickly find out what the problem is and | | | | Next click on close and make any necessary changes |
| you will soon be able to fix it and continue doing your | | | | that are needed in order to correct the formula. |
| work. | | | | When you have done this, go into the formulas tab |
| Firstly, you will need to click the show calculation | | | | and click on the show formulas button, this will hide |
| steps button in the error checking dialog box. This will | | | | the formula and display their results instead. |
| display the formula dialog box. Make a note of the | | | | When using formula, it is very easy to make |
| formula and the underlined item. Next you will need | | | | mistakes and come across problems because they |
| to click the evaluate button to see the formula with | | | | are so delicate and require everything to be correct. |
| the result of the underlined item included within it. | | | | If this happens to you, fixing the problem is made |
| Now that you have the formula up, inspect it and | | | | easier because you are able to make use of the |
| attempt to identify the source of the problem. If the | | | | tools Excel provide you to evaluate and solve the |
| error is shown, yet you are unable to identify the | | | | problem with your formula. |
| source, click the restart button. Continue clicking the | | | | |