In this case, the formula calculates (as it returns a value), but the result is incorrect (instead of score in Exam 2, it gives the score in Exam 1).Īnother example where you need to be cautious about the arguments is when using VLOOKUP with the approximate match. If I use the below formula, I will get the wrong result, because I am using the wrong value in the third argument (one that asks for Column Index number). If you provide a wrong argument or don’t specify the optional argument (where it’s needed for the formula to work), it’s going to give you a wrong result.įor example, suppose you have a dataset as shown below where you need to know the score of Mark in Exam 2 (in cell F2). Let me start by pointing out the obvious.Įvery function in Excel has a specific syntax – such as the number of arguments it can take or the type of arguments it can accept.Īnd in many cases, the reason your Excel formulas are not working or gives the wrong result could be an incorrect argument (or missing arguments).įor example, the VLOOKUP function takes three mandatory arguments and one optional argument.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |