What is wrong with my Formula?

Asked By Buttercup Mines 20 points N/A Posted on - 01/14/2012

(“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.

• Status: Open
• Question Views: 928
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Software

Answered By Lee Seen 0 points N/A #115518

What is wrong with my Formula?

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

About Lee Seen

Questions
0

Answers
101

Best Answers
16

• Vote Up 0 Vote Down

• Posted on - 01/15/2012
• Question Category: Misc Software