if and

Hi, Is there a way to use the Range.Find to look for multiple criteria instead of just one value, and not withing a consecutive range, but multiple columns across rows? I'm assuming it can be accomplished by using the "AND" but I don't know where to place it in the function. In my case I...

Hello! I am using a formula to calculate the number of days between two dates, and then highlighting cells based on that number: =(DATEDIF((B5-44),B3,”D”))>179 -- if the number of days between two dates is greater than 179, then highlight a cell. This formula is working great for me, but I...

Dear Forum, I would like to check the date(stored as date in column j) falls after 01/05/2015, before 30/06/2015 and i= "sanctioned" then it should calculate f*1 else 0 for this i am using the below formula but i am not able to get the true value even though date falls between the mentioned...

so i have 4 columns... Column A is a unique identifier, Column B is a name for this unique identifer Column C is another column of unique identifiers Column D is another column naming this unique identifier how can i create a formula that will goto column A, look at its name in the same row...

Hi there, I've already tried researching and experimenting on different ways to fix the problem that I have with my workbook. I am trying to nest together multiple IF AND formulas together. Scenario: <tbody> A B C 1 Team Name Dex Code Sense 1 2 Green GreenYes Yes 3 Green GreenNo No 4...

Hello, I need a little assistance determining a formula to use for this problem I am having. Take the example. I have my data table. Its a couple of columns <TBODY> Folio DATE Count REIM R/T 14855</SPAN> 3/16/2014</SPAN> 1</SPAN> 452.00</SPAN> 515.11</SPAN> 52235</SPAN>...

Hello Forum Experts! I have a dillemma I hope someone may be able to help solve. I have 2 sheets in the same workbook, RAW and Defects. Both sheets have mostly the same Headers but not in the same order. On the Defects sheet, I am trying to populate an 'Order Status' from the RAW sheet if...

Hi Guys, Need a bit of help with this formula please: =IF(AND(A3="Product 1",B3<=49),B3*F3*(INDEX('Stock Prices'!$B$2:$B$65,MATCH('Company Inventory'!D3,'Stock Prices'!$A$2:$A$65,0),IF(AND(A3="Product 1",B3>=50),B3*F3*(INDEX('Stock Prices'!$C$2:$C$65,MATCH('Company Inventory'!D3,'Stock...

https://docs.google.com/spreadsheet/ccc?key=0AlkV6TxHhBO3dEhJb1pIeks0N2drOE40OU5nNmhPeXc&usp=drive_web#gid=0 The table is a tracking for equipment rental. Each Door No. has a history, for example the Door No. ATC0005 took up the Cell A2 to A8. Each history has a record of Date Mobilized and...

I have a workbook (named Pay Ranges) with pay grades 1 -25 and 3 pay rates for each grade based on years in title. In another workbook (named Scenarios) I am running scenarios based on data in the Pay Ranges workbook. The scenario workbook contains the employee name, current pay grade and...

Hi, I am using a table below that contains a large amount of data; approx. 1800 unique rows, that will grow to 3500 potentially. I have various "Groups" within the data and want to create a separate workbook containing just 1 of the data groups. I have tried advance filters and IF calculations...

I have a list of 4000 Letters. Each letter has a revision 1 and revision 2 (so effectivly 8000 letters). Each revision has a response due date and actual response date. My query is: I would like to plot on a timeline showing in colour the delay period. (If the Actual response Date is > than...

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...

I have multiple conditions for Or and And that need to be in an If statement. How do I write the IF statement? Thanks in advance! Conditions: <tbody> If A or B is no, then no If A or B is maybe, then maybe If A or B is NA, then take the other cell Else, Yes <tbody> A B Should...

Hi All, i got brain freeze this morning, im trying to wright an argument, where if the value is less than 309 answer is poor, between 309 to 462 it is Average and between 462 and 616 Good and above 616 is excellent, now i also need to add the 309 to the "poor" and Good to 462 and Average to the...

I have this code that sends an email if the certain conditional formatting conditions are met the code is below If x - Cells(3, 4) > 30 Then Dim i As Long i = 7 'code to see if a relief valve has to be retested' Do While Range("A" & i) <> IsBlank If Range("L" & i) = "" Then 'If the cell...

Hello, I wrote a code snippet that checks a cell for a number value (any number value), and if it finds it the header of that cell appears in another cell. What I want to do is nest (?) additional cell checks so that the final cell has all of the headers. =IF(ISNUMBER(C3),C2&",","NO") C3...

I am creating a financial model where I am trying to calculate the NPV and rNPV of several assets. One of the potential streams of revenue is a one-time 'milestone' payment of $30M if/when the cumulative sales of the product exceeds $500M. I have projected revenues from product sales for years...

I know this should be easy, but i'm having no luck. I want to say If column A is "N" and Column B is greater than 10-July-2011 display a Y I would think it should be something like: =If(And(A1="N",B1>10-JUL-11),"Y","N") but this results in #NAME? I know the problem is with my date, but i've...

Hey, I've got a real head scratcher and I hope someone out there can help me. Here is the situation: I have 4 dates -- Budgeted Possession Date, Actual Possession Date, Budgeted Commencement Date, Actual Commencement Date. Budgeted Possession always comes before Budgeted Commencement and...