We read a brief about Microsoft Excel built in functions in earlier post. Now let's see a bit more of functions and related stuff in this final post on functions introduction.
If you enter incorrect inputs or do not follow the function syntax correctly, the result would be an error. Let's have a look on few common mistakes people do and how to correct those.
Types of Formula Errors
Though you would take precautions, formulas resulting an error is common most of the times. Let's look at common errors that your function results into. Note that the reasons for errors and how to resolve them are situation dependent hence will be different in different cases.
Now that we know the types of errors and what causes them, we can make sure formulas are entered as required. Next time we will see how to check where the errors occurred and how to debug them. See you then!!
If you enter incorrect inputs or do not follow the function syntax correctly, the result would be an error. Let's have a look on few common mistakes people do and how to correct those.
Types of Formula Errors
Though you would take precautions, formulas resulting an error is common most of the times. Let's look at common errors that your function results into. Note that the reasons for errors and how to resolve them are situation dependent hence will be different in different cases.
Now that we know the types of errors and what causes them, we can make sure formulas are entered as required. Next time we will see how to check where the errors occurred and how to debug them. See you then!!
No comments:
Post a Comment