arguments

  1. J

    Not Equal to, if statement

    This is super easy for the experts but I can't figure this out with 2 arguments If cell D9 does not equal "WI" or "IA" then return a 1 - otherwise display 0
  2. K

    Too few arguments / formula is missing an open/closing parenthesis

    <colgroup><col width="64" style="width:48pt"> </colgroup><tbody> I copied the formula from a similar one in another thread here, but keeping getting either "too few arguments" or "closing parenthesis". Help? IFERROR(IF(I3="AVG",VLOOKUP(A3,'Master Table'!$A$3:$Z$3537,22,FALSE),IF(I3="P1/CY...
  3. L

    Using Application.OnTime

    Hello guys, I'm trying to setup a timeout for a macro I'm creating, it reaches out to a file, if that file is open it times out for 10 sec and then tries again. My initial approach was to make a do loop for x seconds, but that was an awful idea because it prevents other actions from happening...
  4. L

    SUMIF in Calendar Format (Too Many Arguments)

    I'm building a calendar format spending tracker. I'd like to keep track of daily, weekly and monthly costs; and then also track costs by category (see image below). The tracking by category is what has the SUMIF function not working. I've been trying to select specific cells to look to, but I'm...
  5. leopardhawk

    Index / match

    Hello forum friends, can someone please tell me what is wrong with this formula? I keep getting the error that I have entered too few arguments. =index(B55:B116,match(year(now)),A55:A116,0)) Column A has years in it and column B has dollar amounts. <b>Excel 2016 (Windows) 32 bit</b><table...
  6. C

    Getting Application.onTime to work in a For Loop correctly

    This code Private Sub cmdFindDate_Click() Dim i, n As Integer Dim t For i = 2 To [A65536].End(xlUp).Row n = Day(Cells(i, 1).Value) If n = Day(Now()) Then t = Now() + TimeSerial(0, 0, 10) Application.OnTime t, "RunNewSetMSG" Else MsgBox "value...
  7. S

    Evaluate any UDF arguments as is, as a cell in excel would do

    How do I evalute myudf as excel evaulates its own in-built functions? many experts has said it is imposible , VBA doesnt have native ability to this, and to basically "Go and learn Python or C" instead. And there are many ways to do this. But I think VBA can do this, becuause some UDF's...
  8. N

    Why Am I getting too many arguments for function

    Hi, I feel like I've rewritten and modified this formula over and over again, but can't figure out where I'm missing something. I'm getting a "too many arguments for this function" error for the following nested if...
  9. J

    Formula to count blanks and specific characters

    Good Morning, I am terrible with formulas and was hoping to get some help. I'm trying to create a formula that counts blanks as well as any cell that contains these characters ("O", "TR", "LD", "D"). I keep getting a too many arguments error. Is this even possible? Here is what I thought the...
  10. T

    Passing argument via the calling procedure

    Looking at this: https://www.mrexcel.com/forum/excel-questions/573357-prevent-vba-editor-being-opened.html in particular this code: CBTProc = CallNextHookEx _ (lCBTHook, idHook, ByVal wParam, ByVal lParam) What is the significance of adding ByVal? My understanding...
  11. A

    IFERROR too many arguments

    I can't seem to add the IFERROR to =IF($A23<>"",INDEX('Equip & Sub'!$A:$I,MATCH($A23,'Equip & Sub'!$A:$A,0),2),"") Keeps saying You've entered too many arguments for this function Help please.
  12. P

    adding more to formula

    this formula works perfect until i add more to it =MAX(FREQUENCY(IF(ISNUMBER(MATCH('Match Database'!$H$2:$H$5000,{"Won","Drew"},0)),ROW('Match Database'!$H$2:$H$5000)),IF('Match Database'!$H$2:$H$5000="Lost",ROW('Match Database'!$H$2:$H$5000)))) (which is an array formula)...
  13. Z

    Excel Formula - Too Many Arguments Error

    Hi, everyone. When I try to use the formula below, I always get the error in Excel saying " You've entered too many arguments for this function." What do you think is wrong with the formula below and how can I correct it...
  14. A

    Help with formula with too many arguments

    I can't find where I'm going wrong with this formula! Can someone help? =IF(AND(S3=S2,V2>Noon,V2<One),V2+TIME(1,0,0),IF(AND(S3=S2,V2>TIME(1,0,0)),V2),if(not(S3=S2),nine)))
  15. T

    Paramarray

    I want to write a function where the first argument is mandatory (the year) but subsequent arguments vary from no arguments to as many as entered. Is that possible? I don't want to write: Public Function MyFn(Year, Optional Loc1, Optional Loc2, Optional Loc3, Optional Loc4, Optional Loc5...
  16. N

    Too many arguments

    Hello I'm creating a quoting system based on the A) the type of door and B) the size of door. I set and array for each door and the sizes available and the sales Price. I'm using IF the door is the style, then look at that particular array for its size and return the selling price: The...
  17. S

    Hello again, need to retrieve the cell calculations of the formula and not the results. Whats the way of doing it again?

    I've done it before. Its not f9 (which shows the calclatations in parts of a formula). Besides, f9 is not working for me right now. Its something else which is quite simple. But havn't (though should and could have) used all this time. I did it once for a concatonate. Now want to do it for...
  18. E

    Trying to nest formulas/put them all in one cell but keep getting "too many arguments" error?

    Hi I been working on this on and off for nearly 5 hours straight and when I look at the it everything just all blurs into a mess so I would be very grateful for a fresh perspective or pair of eyes.? I am trying to combine the three formulas below in to one so that they are in the same Cell...
  19. Z

    Formula with several arguments

    Good day If someone could be as kind as to assist with the following, I am tracking Personnel on Board (POB) on a daily basis. Column A to N has names, surnames etc... which one of the columns include company they work for (F). Column O - EX has Dates (sequential). On each new day a 1 will be...
  20. N

    Too many arguments

    I am trying to get rid of the 0 in a chart by replacing it with #N/A. The cell in the chart takes its addition from other sheets in the same workbook. I have googled this to find out the best way but when I try to use the method described, I get the error message that there are too many...

Some videos you may like

This Week's Hot Topics

Top