too many arguments

  1. K

    You've entered too many arguments for this function

    My current formula is =IF(D$14>EOMONTH($C15,0)-$C15+1,"NA", IF(OR(DATE(YEAR($C15),MONTH($C15),D$14)<I_ER_START, DATE(YEAR($C15),MONTH($C15),D$14)>I_ER_END),"NA", IF(OR(DATE(YEAR($C15),MONTH($C15),D$14)<C_EMP_START, DATE(YEAR($C15),MONTH($C15),D$14)>C_EMP_END),"NE", IFERROR(...
  2. J

    Airplane weight and balance

    I'm trying to write a formula for a aircraft weight and balance. The rear arm limit remains constant, but the forward limit shifts after reaching a certain weight. EX: Weight up to 2050 forward limit is 82.0 and rear limit is 93.0. Weights between 2050 and 2550 the forward limit shifts aft at a...
  3. K

    Too many arguments to function in "if" function

    Hello I wrote a formula in order to trace the boundaries of some wind values. The boundaries are 0-90 / 91-180 / 181-270 / 271-360, and in return I want to get 0 for the first group, 1,2,3 for the second,third and fourth respectively. The formula is the next one...
  4. S

    Nested IF functions giving Too Many Arguments error

    I have a workbook where I input information in specific cells to create combinations to calculate employee bonuses. My workbook has 4 tabs: Data Bonus Base Bonus Summary The Data tab is formatted like this: <tbody> Column A Column B Column C IF formula below Base Salary? Employee...
  5. S

    Combining Nested IF functions

    I have a spreadsheet that allows the user to input different employee/bonus combinations and based on the combination, I have assigned a number 1-4. For instance: A = 1 A+B = 2 A+C = 3 A*B = 4 I created a large nested IF statement to account for every combination, but I have two combinations...
  6. C

    Too many arguments for this function error

    I am trying to use the following formula - to contain 2 IF statements...
  7. S

    Average, Excluding Zeros, BUT it's not a Range, but selection of Cells. What's the formula? I get an Error

    Please help. I've tried using the following formula options, but keep getting an error due to "too many arguments". All my searches turn up formulas for averaging a range of cells where's I'm using a selection of cells not in a range that I can set apart with a colon. Please help. Thanks in...
  8. O

    Too many arguments

    Hi everyone! I've researched, tried different solutions, got help from a friend at work. I'm flummoxed... =IF(AND(E2>0,F2>0),(Main!G11-(DAYS(F2,E2)))/Main!G11,IF(AND(E2>0,F2=""),DAYS(E2,Main!D11)/Main!G11),IF(AND(E2="",F2>0),DAYS(Main!F11,F2)/Main!G11)) Your help is greatly appreciated...
  9. anna82marie

    ISERROR Function - Too many arguments: Please Help!!

    I'm having an issue trying to get the following formula to return N/A instead of #VALUE! =IF($K8>$F$5,(TODAY()-$K8)*($O8*0.2739726%),(TODAY()-$F$5)*($O8*0.2739726%)) Can anyone help me to do this? I can't get my head around it at all and have a deadline looming. Any help would be really...
  10. N

    Too many Arguments--INDEX issues

    =VLOOKUP($A$3, 'SAP Data'!$A$3:$A$7,1,FALSE,INDEX('SAP Data'!$AL$3:$AL$4805,SMALL(IF('SAP Data'!$AK$3:$AK$4805>=H3,IF('SAP Data'!$AK$3:$AK$4805<=N3,ROW('SAP Data'!$AL$3:$AL$4805)-ROW('SAP Data'!$AL$3)+1)),ROWS(H$3:H3)))) The above is the formula I'm using, just a little long. I'm using...
  11. X

    Help with YTD Average formula.

    Hi i'm working on a spreadsheet to show the monthly and YTD averages of Hands per hour/Spins per hour on 3 casino games. the problem i have is my YTD average has DIV/0! error , i want the ytd average to ignore months that haven't been input yet. e.g BJ hands per hour in Jan=70 so at this point...
  12. I

    Macro function returns "too many arguments' error

    When I insert the function pv() it returns an errorr message "You've entered too many arguments for this function." But I haven't called out too many arguments. Even worse is that I can call out functions pm(), pq() or pd() which are all similar but work! Here is the code for these functions...
  13. L

    Too many arguments

    Hi, I am trying to use a VLOOKUP function to fetch a value from a table on sheet 2 dependant upon the value entered in cell D1. I have done it for the first two columns in the table on sheet 2, but when I try to enter more, it says i have too many arguments....any ideas? The formula I want to...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top