if and

  1. Jyggalag

    Iferror(Index&Match&Match) formula

    Hi all! I currently have a large worksheet that is similar to this: With the master data looking like this: I want to create a sort of IFERROR(IF(INDEX=0, ,MATCH and MATCH formula (with an iferror that returns "" (blank) if there's an error)) for every column with [] such as [DATE]. So...
  2. A

    Count if two column ranges contain same value

    Hi, Need to count 1 every time a cell in range 'CHO1'!E2:E1000 contain the letter Y And the corresponding cell in range 'CHO1'!H2:H1000 contain the letter Y. =IF(AND('CHO1'!E2:E1000="Y",'CHO1'!H2:H1000 ="Y"),1,0) does not return anything. I would expect to return 2 for below.
  3. T

    If this Date Range and This Cell Value Match?

    Hello, I am trying to highlight a collision if the date ranges in columns B and C coincide as well as the values in column F. The collision column G should then be either red, or indicate yes or an x. How would I express this? Thank you!
  4. B

    IF statement with concatenate to show resubmitted work

    Hi Everyone, I'm trying to figure out a formula to show if a request was rejected or approved. We make trackers twice a day and the only way to notice if a request is rejected, is if it shows up twice but with a different date. Providing example 135969 HIERARCHY HIERARCHY ARTICLE_CHANGE...
  5. B

    Multiply Cell by Two Different Numbers Based on Range

    I am attempting to create a formula in B6 that considers the following criteria: If SUM B1:B2 <100 then SUM(B1:B3)*28 If SUM B1:B2 >100 then multiply the first 99 hours by $28 and every hour worked thereafter by $32. Then add B3*28. * B1 & B2 are the only hours to be considered regarding <...
  6. M

    VBA Match Month & Year in Row to Month & Year from another cell

    Thanks in advance for any help! I'm trying to locate the month and year contained in a row of one worksheet that matches the month and year contained in a cell on a different worksheet. Then copy the matching column to a third worksheet. With the below, I'm receiving a "Type Mismatch" error on...
  7. A

    Multiple AND and Parenthesis

    Hello all - If anyone has a moment to help with this, I would be greatly appreciative, thanks - In O365 excel tells me there is a problem with my formula. I have tried a good many versions of this trying to work it out, and (think) it is in the parentheses. If this is indeed the case, and you...
  8. R

    Conditional Formula: Using 'If' 'And' and 'Or' - solution will save days of work!

    Goal: IF Column E is Blank AND Column M OR Column T are <0 True= "Review" False= Blank I can write the 'if/and' but when I include the 'or' my results are meaningless.:confused: Any help appreciated, as a solution will save me days of work.
  9. Johnny Thunder

    Excel Formula Help - Multiple IF/AND Statement with Dates

    Hello All, I am in need of some help with a hard IF/AND Statement with multiple variables My current Formula: =IF(T$4=$J9-1,$Q9*0.3,IF(T$4=$J9,$Q9*0.5,IF(T$4=$J9+1,$Q9*0.1,""))) Definitions T$4 = is my header date (Formula is dragged left to right in the same row $J9 = My Starting Date...
  10. M

    IF with 3 conditions

    Hi I'd like to write a formula that i) checks that J1 is not blank i) checks if the word "for" is NOT in a cell J1 ii) checks if cell K1 is equal to 0. I've tried this formula but it's not returning the result expected. =IF(AND(J1<>"",K1=0,COUNTIF(J1,"*for*")),"Code","Blank") Please...
  11. 4

    Cumulative max with IF AND statements

    I need help with creating the correct formula for the Employer Matching column (Column G). The employer matching formula is the lesser of 50% up to 6% of Gross Wages OR a maximum of $8,400 (which is 3% of $280,000). Once Gross Wages reach $280,000, the employer match will no longer accrue. Also...
  12. A

    IF, AND, VLOOKUP help

    Hello, I am trying to do a If And with a vlookup within the same workbook. IF(AND(IF(AF3431="Red",VLOOKUP(AG3431,'VLookup Table'!E:F,2,FALSE),IF(AF3431="Blue",VLOOKUP(AG3431,'VLookup Table'!E:F,2,FALSE),IF(AF3431="Green",VLOOKUP(AG3431,'VLookup...
  13. Z

    Building a logic for multiple conditions

    I need to build logic for below statement: If 2018 Favorability % is greater than 2017 Favorability %, and if 2018 Favorability % is greater than or equal to 70% and if the difference of Favorability percentages 0f 2018-2017 is greater than or equal to 10%, then “positive”, other than that...
  14. Z

    Labeling Generations

    Hi, I have list of employees and their date of birth, I need tolabel each employee with the right generation name according to the list below: <tbody> Generation 1984-2002 – Millennial 1946-1964 – Baby Boomers 1965-1983 – Gen X 1946-1964...
  15. M

    Help with IF AND function

    My excel formula =IF(AND(E16="Lara",G16="1"),F16) is returning FALSE E16 = Lara G16 = 1 F16 = NewBusiness My formula should return "NewBusiness", what did i do wrong? l
  16. B

    Excel IF + AND or OR Statements

    I am trying to do two things, but can't seem to get my IF statements to work. I have a date in column M, time in column N, and day of the week in column O. I want to add information in columns P and Q: 1. I am trying to show when a day would fall on a weekend or holiday. I created a table...
  17. A

    Nested iF, AND formula.

    Hello everyone - I would love some help with this formula if someone is willing to give it a go: =IF(BG2="RT",IF(AND($AR2="x",$AZ2="L",$J3<= $BF2),"Y",IF(BG2="RT",IF(AND($AR2="x",$AZ2="S",$I3>= $BF2),"Y",IF(BG2="T",IF(AND($AR2="x",$AZ2="L",$J3<=...
  18. H

    If and with multiple conditions & cells

    Novice Excel user trying to figure out an if and formula <colgroup><col><col span="2"><col><col></colgroup><tbody> <tbody> BR CLOCK $2 BR CLOCK $2 BR TABLE $5 BR CHAIR $3 LV CLOCK $3 LV CLOCK $3 LV CLOCK $3 LV CLOCK $3 </tbody> </tbody> Essentially I am trying to say if...
  19. S

    IF AND - multiple statements - VBA EASIER WAY??

    I have about 12 statements that I need to verify are "TRUE". However, something that seems like it should be simple is causing me headaches. I am working to incorporate this into a macro and thus far, I've just gone ahead and used the: =IF(AND formula to try and help me sort out the problem...
  20. M

    Combining IF AND and IF OR Statements

    Hi there, I've been banging my head upon this for the past few hours and so I thought best to defer to the experts. IF E3 = "Closed" OR "Rejected" AND S3 = "", T3>0, M3>0 (All 3 conditions must be met) Here is the formula I have so far... I've not yet figured out how to include "Rejected"...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back