What is wrong with my Formula?

Asked By 20 points N/A Posted on -
qa-featured

(“Too many arguments”). This is the message I am receiving when I try to execute the following formula that I myself have written: (MATCH(V2, Data!A2:A16,0)- MATCH(G2,Data!A2:A16,0)/3. I cannot tell where the problem with the formula is. Kindly help me with this.

SHARE
Answered By 0 points N/A #115518

What is wrong with my Formula?

qa-featured

Which program are using to develop the code? "Too many arguments" is an error that simply means that you are using many functions in the same statement and therefore leaving the application that you are using a bit 'confused' now how to handle them. Like in the example code that you have pasted above, you will notice that you have used brackets a lot of times and brackets imply that you are carrying out multiplication, there is also a subtraction, division, ratio and match all being carried out in the same statement. You will therefore need to divide the statement so that it is solved in bits and make the computer understand your statement.

-Lee Seen

Related Questions