and function

  1. M

    Nested IF AND OR 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...
  2. C

    Conditional formatting with AND

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

    Need Help with Two Condition Combination Formula

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

    Nested IF formula problem

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

    Best way for multiple condition to be meet for answer

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

    IF and AND with Dates and Times

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

    only add duplicate values once based on content of other columns

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

    If , and , ......im struggling

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

    Trying To Use Formulas To Add Numbers with Only 2/3 Sets of Criteria

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

    IF/AND/OR Functions HELP

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

    Index/Match Array Formula Help

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

    Use Lookup formula with the MID function

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

    IF OR functions, unless a certain condition is met

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

    Multiple conditions within one cell, need help with if/and/or statements

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

    SUMIF with 2 conditions

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

    Using Countifs formula with And/Or operator (?)

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

    Linking two sheets using the AND, IF and OR functions

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

    Multiple logic - If/OR

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

    CountIf with conditions

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

    IF AND Formula Help

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

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top