if formula help

Hi everyone! Im starting to go crazy. I'm feeling quite handy with excel and its lovely IF formulas, but I bumped into a problem I can't seem to solve! I am building a backtesting model for our option trading strategy, where we have a couple of constants: - Friday at the end of the day we...

Hi, I'm not a very experienced excel user and I'm struggling with getting the formula right on this one. You will see the columns I am dealing with below. Basically, I need column C to produce either a date or N/A. If the date in A is before 1st June 2022 then the date in C should be 31st...

I have the following IF statement that is not producing commas or two place cents. =IF(AND(B88>-100,B88<100),"No Difference",IF(AND(B88>-100000,B88<100000),"Immaterial Difference",IF(AND(B88<-1000000,B88>1000000),B88&"Difference",B88&"Difference"))) This is producing a number like...

I’m trying use and IF formula with networkdays and I want it to stop when a process is filled cancelled or on hold, for some reason it is telling there is a missing parenthesis. At this point i don’t know what to do: Any advice will be well received =IF(T20="Cancelled";NETWORKDAYS(U20;Z20)...

I'm having a hard time figuring this one out. I have a date in cell A. If today is greater that 6 months from the date in cell a, how would I forumlate cell b to have an x? I want my spreadsheet to look like this: Date 6 months 12 months 2/12/16 8/5/15...

I am working with a large spreadsheet that contains specific names and 4 columns over contains a numerical value. What I would like to be able to do is search for the specific text and then have the formula return the value to the right. Example: Pete is located in cell C4, C12, E1, G5. In...

I am trying to create a formula where if the condition of a cell is met then it displays the content of the cell instead of True/False. For example <tbody> 400 800 =400/800 50% -400 800 =-400/800 -50 240 800 =240/800 30% </tbody> The formula should display the actual percentage if the...

The problem i'm facing is that C8, C9, and C10 all have to be positive values and less than C4+C5. That part I've figured out and is fine but the problem is that C9 has to be greater than C10. I set it so C9 has to be between the above restrictions and set C10 so the minimum is C9. The...

Hello everyone! I am trying to insert the following formula into my current code: =IF(B2="","",B2+30) This formula is pulling the date entered into cell C2:C and responding in D2:D by adding 30 days to that date. I am not sure how to do this. Can anyone help?! What I am wanting is for the...

Hi, i have a worksheet that will be constantly updated. In C60:CH60 i have an if formula which looks at newly added data (in D100:DH100) and updates the data in C60:CH60 to the most recent data inputted in D100:DH100. If there is no new data, i have it returning the sum of data from a table...

<tbody> Active/Inactive Customer Last Name Customer First Name Insurance Co PolicyType Policy # Written Date Effective Date Renewal Date Policy Pays Every Premium Amount Net Commission Active Doe John Ins ABC Auto 123 02/02/2013 02/07/2013 08/07/2013 6 Months 500.00 60.00 Active Smith...

Hi Folks, Excuse my stupidity, I have a fairly straightforward excel formula question. I am trying to use the following formula: =IF(ISBLANK('Contract Compliance Month 3'!F38:F39),COUNTA('Data Sheet'!D7:D64)) if a certain cell, F38:F39 is filled, run the counta formula and display the total...

Hi, I was wondering if there is a way (official or a work-around) to conditionally format a cell depending not on the result of the formula but on what it did in the process. My particular case is a series of "IF" formulas embed within each other. For example: "If this number is blank, then grab...

Hi All, Please forgive me if I do not explain myself clearly; I am rather new to Excel. I am trying to create a formula that will populate a cell with text depending on an entry in 7 other columns. Only one of the seven columns will have an "Yes" entry. This is what I have so far that is not...

I'm trying to use a adv filter to pull out, in a separate table, items from a table which meet a criteria based on a formula ie. the criteria should look at 'starting column' F, and is only if that number is smaller than the sum of columns D & E. If tried a IF Formula but cant seem to get it...

Hello everyone, I really need help with a formula! <tbody> Invoiced by Company Amount Lead To XY To AB XY 600 XY AB 2560 AB XY 1000 AB AB 1500 XY </tbody> I need to create a formula whch says that if money is invoiced by XY and is is the lead of XY the amount must be...

Is it possible to simplify this formula? =IF((SUM(P27,T27,X27,AB27,AF27,AJ27,AN27,AR27,AV27,AZ27,BD27,BH27,BL27,BP27,BT27,BX27,CB27,CF27,CJ27,CN27,CR27,CV27)>0),SUM(P27,T27,X27,AB27,AF27,AJ27,AN27,AR27,AV27,AZ27,BD27,BH27,BL27,BP27,BT27,BX27,CB27,CF27,CJ27,CN27,CR27,CV27),"")

I have several work sheets that have salary, purchases, travel instate, travel out of state... that I populate for the accounting purpose. Each row entry is made for an individual or department. At the end of the workbook each individual or department has their summary page that will show only...

I have established two tables: the first being records over a long period of time(lets call it "AllTime"), including names; the second being only the names of current employees (lets call it "Current"). I am trying to establish an equation in a column of the "All-Time" table where if an employee...

Hi everyone i need help with creating a formula in the following instance..:confused: If value of cell in the range of E2 through to E17 is between 100 and 139 then +1 in K2 but i also need the '1' in K2 to remain even after the values in E2-E17 have been deleted and if another value in the...