arguments

I want t enter three arguments into one cell: 1. Calculate total days overdue 2. Mark "Received" if date in received column 3. Leave blank if not overdue So far, I have =IF(G3>1,"RECEIVED",DAYS360(F3,TODAY())) and I get arguments 1 and 2, but I can't figure out how to add argument 3. I've tried...

Im trying to find all the max and the min in the data set by the slopes and for some reason my if statement wont work If 0 > ((Cells(i + 1, 2).Value - Cells(i, 2).Value) / (Cells(i + 1, 1).Value - Cells(i, 1).Value)) And 0 < ((Cells(i + 2, 2).Value - Cells(i + 1, 2).Value) / (Cells(i + 2...

=IF(C10="01", "No Sub Project", IF(C10="03", "Sub Project 1", IF(C10="04", "Sub Project 2", IF(C10="05","Sub Project 3", IF(C10="06", "Sub Project 4", IF(C10="07", "Sub Project 5", IF(C10="08", "Sub Project 6", IF(C10="09", "Sub Project 7", IF(C10="13", "Sub Project 8", IF(C10="14", "Sub Project...

Hi all, I have a multiple IFs condition formula which works fine below: =IF(AND(I200="",J200="",K200=""),"N",IF(AND(G200<today(),h200<>"Complete"),"Forecast End Date is before current date - Status needs to be Complete or Date needs to be updated. Note: Status also cannot be...

I would like to show the xlDialogOptionsListsAdd dialog and retrieve the name or index of the custom list that was selected. I can show the dialog easily using: Application.Dialogs(xlDialogOptionsListsAdd).Show but I'm guessing that if I want to know what value the user selected, then I have...

Hello Everyone!! I was hoping I might get some help regarding an issue I'm having with IF statements as a function of date. So I'm working on a project reporting tool that has all of the projects for my department and their status, be it Ready, Not yet due, due withing two weeks or late. The...

Hi, Please look at this formula: =SUMPRODUCT(--(B1:B10=A1),--(C1:C10=A2)+(C1:C10=A3),D1:D10) I would like to make same criteria averaging D1:D10 (IF B1:B10 matches A1, C1:C10 matches A2 or A3, average D1:D10. Tried with...

I am able to run a Shell command to run a batch file from within a VBA macro, but I'm failing when I attempt to add a command-line argument. Can you tell me what is wrong with this? Sub MassageData() Dim PathCrnt As String Dim sString As String sString = InputBox("Enter Search...

Help. I am getting "you've entered too many arguments for this function". Does anyone know how to add more? I am trying to use: =IF(C5<1000001,C15,IF(C5<2000001,C17,IF(C5<3000001,C18,C19,C20,C21))) for the $1.5M , $4M & $5M option but it won't let me add C16, C20 & C21 for column one...

Hello again guys, So I have an error handler that formats cells displays a variety of different error messages depending on where the user is in the process: sSubs is either a string or array of strings containing macro names that will be run. iPhase and iSteps are for identifying what stage...

I trying to have the answer but I’m stuck in the last argument. This is what I have so far: · Less than (30) = 6 Month Duration · Greater than or equal (30) = 12 Month Duration · Less than 500 = 6 months · Greater than or equal...

I need some assistance. I have a formula already but I need to add for more columns to it and I keep getting the error message - "you've entered too many arguments for this funtion" Below is the original formula and what i need to add. =IF(ISNUMBER(MATCH("x",K5:N5,0)),CONCATENATE(FY_11_Word,"...

I want to do a loop, processing against a set of variables, all of the same type. I think I could put the set of variables into a range and read them from there, but didn't want to add a bunch of ranges. I'd like to do it something like described below, but haven't found a close enough...

So I have a log at work for orders from people in the office that is the format: "Person Who Placed Order"-"Person Ordered For" The account number in the next cell is represented only for the "Person Ordered For" and should correspond to their name. Since there are a large number of orders, it...

All, Just curious if it was possible to divide an array into individual values (or objects) that could later be passed to a ParamArray argument. For example, say I have an array of ranges, and I wanted to pass the entire array to Application.Union. Right now, the only way I could do this is...

I've got a VBScript file that I'm trying to get to populate an Excel spreadsheet with the file names dropped onto it. It works with a few files, but when I try to dump like 21 or more files on it I get an error saying it can't process that many arguments. Dim arg, cnt Set objExcel =...

I just started fooling around w/ VBA yeseterday, so I'm still getting my bearings. I know how to create functions in which the arguments are explicitly stated i.e. Function LINK3(num1, num2, num3) num1 = (1 + (num1 / 100)) num2 = (1 + (num2 / 100)) num3 = (1 + (num3 / 100)) LINK3...

I have a spreadsheet set up that cannot be altered and I am trying to sum every other cell in a column with 80 rows. There is a max of 30 arguments allowed - i.e., =sum(a1,a3,a5,...). How do I solve this?