arguments

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

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

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

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

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. Excel 2016 (Windows) 32...

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

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

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

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

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

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.

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)...

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

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)))

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

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

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

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

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

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