and function

Hello - I'm trying to evaluate the contents of two cells with 4 possible values. I3 can contain either Active or Inactive J3 can contain either YES or NO IF I3="Active" AND J3="YES" OR IF I3="Inactive" AND J3="NO" THEN "Match" ELSE "No Match" I've tried several combinations and am not getting...

Once again I'm back to my new favorite forum with a new question! On this sheet, Column L is pulling a date from Spreadsheet "0 Revised LOS". Column N4 has a date that is manually entered. I'm trying to use the conditional formatting to highlight the cell in Column N if Column L's date is...

I need some help creating a combination formula that checks for two conditions to be true. Column A and Column E in my spreadsheet will contain random values of which may or may not be listed below. My current formula in cell E* checks to see if the value in Cell F* meets the condition of...

Hi, to start, I am using Windows 7 with Excel 2013. I have a table that setup as follows, with each month being a separate column header and 2015,2014, and Trend as my row headers January February March April May June 2015 6 2 4 1...

All, I am trying to find the best way to get the correct answer from the below table. Basically the answer will depend on 2 things: The percentage range in A & B The value the product is between. I have two cells in another sheet, one states the percentage, and the other the amount. What I...

Hello, I work for a Transport company. We send notification to our customers as to when we will be delivering with a given window of 2.5 hours. Our planned delivery date/time is (G3) 05/05/15 08:19 Our start window for this is (H3) 05/05/15 07:49 Our end window for this is (I3) 05/05/15 10:19...

<TBODY> Column A Column B Column C Column D Location Service Shut-in Impact 03-08 WL 3/15/16 150 03-08 AL 3/1/15 11-17 WL 3/15/15 200 11-17 WL 3/15/15 200 11-17 AL 3/1/15 150 11-19 WL 100 11-19 WL 100 </TBODY> Here's an example of the data I'm working with: What I...

Hi I want a formula that does the following: If Cell C2 = Year 2 ($B$3), then Cell C3 = 60% and then D3 = 40% with E3, F3,G3 all zero If Cell C2 does not equal B3 , then Cell C3 = 0 so if Cell D2 = $B$3 , then D3 =60% and E3 = 40% and all cells afterwards F3, G3, are zero.....and so on

I’m looking to create a formula that will look at two separate columns [Status] and [Quarter] and select (for example) HP in column F and Q1 in column. Then add all those particular numbers located in the G column and add them. Example would be an outcome of all numbers added would have both...

Good Morning. I’m having a hard time writing a formula. Every time I do it get it kicked back so I needed some additional help from people. I am attempting to write a function that states if a person is located in the USA and hit their target of 0% or higher they get 10 points. If not then...

Hello all! Every time I hit a brick wall with my spreadsheets I take a look around these forums and almost always find a great solution! Unfortunately I haven't been able to find an answer to my current problem... Essentially it boils down to needing multiple values returned based on multiple...

Hi All, Reference to this thread http://www.mrexcel.com/forum/excel-questions/423808-use-lookup-formula-mid-function.html I want to use same formula in bit different way. But I can't figure it out how? I have a Date "26 January 2013" Sheet 1 <tbody> A B C D 1 Name "ABC" Contract start...

Hi all, What I want to achieve is this: Display me a set value e.g. 10, every time that EITHER condition A or condition B are met, UNLESS a given cell = 0. To give some context, this is relating to deliveries of a product. I am forecasting the costs incurred over a period of years where...

I'm sure this has been answered already, I just can't find it. I'm using Excel 2010 on a windows XP operating system I'm struggling to create a condition in a cell which I will be using later to export data for a sales training progress report. In cell A1 there will be one of 4 things : A) N/a...

Based on furthering this I need to now make it dependant upon two cells, my formula is =SUMPRODUCT(SUMIF(INDIRECT("'"&SheetList&"'!$B:$B"),$B5,INDIRECT("'"&SheetList&"'!F:F"))) I've tried...

I am stuck on how to make a formula that would count how many people in Section B telework on the First Monday of the pay period. The Telework data is in 4 different columns. I am stuck on using the And/Or operators. Any ideas? Countifs(C:C,"Section B") And countifs(F:F, "Monday P1") or...

Hi, I am trying to link two sheets in the following way and for the purpose of ease I'll call the sheets A and B. IF cell B18 in sheet A is greater than cell B46 in sheet B AND cell B18 in sheet B is equal to 1 OR 5 OR 10 OR 15 OR 25 OR 50 then cell B90 in sheet B should equal cell B18 in...

Can someone help me with the formula the following please with the SUM Logic function; I am trying to put prices in - so if they select (for example) apple, banana or orange from a drop down list, the price will be $1, but if they select anything else, the price will be $1.15 So, is there an...

Hi all, I'm hoping someone here can help me solve this formula if it is at all possible. Here's the short story of the problem: Columns and their representation: Columns A through C represents an overview of data collected. A = Names B = Errors YTD C = Errors MTD Columns D through H are...

Hello Not too sure if this is possible, but looking for help with the following formula. =IF(AND(Training_Plan_2011.12!H9,"COM 1"),(Training_Plan_2011.12!A9,"7-Mar"),"Training_Plan_2011.12!I9","") I'm working across spreadsheets and basically trying to get excel to input the value of a...