ifand

  1. H

    Cashflow forecast based on start dates and either monthly, bi-monthly, quarterly, annually

    Hello and thank you for your time: I have a table of overheads. Each overhead has a value in column D Each value is paid monthly, bi-monthly, quarterly or annually stated in column F Each overhead has a start date for when the first payment is due in column G Column H is the start date of...
  2. TheWaterDog

    IFERROR with IF/AND to catch between 2 dates with multiple results......and failing miserably :(

    I know there are people who are going to want to pull their hair out at my stupidity - I want to apologise in advance but I'm so stuck and I don't even know why. Sheet 1 is Schedule Data (B4:Z4999) Start Date is Column Y End Date is Column Z Data I want to be returned is Column B Sheet 2 is...
  3. E

    vlookup with match to return a result with multiple rows with lookup value

    So I have a doozy of a question. I have 2 tables. Table 1: contains a list "Sites=siteID" on each row. Columns contain "Device Name" 1-30 Table 2: contains "SiteID", "Device Name" SiteID is over multiple rows See examples Table 1: Site ID Device Name 001 Device Name 002 Device Name 003...
  4. L

    how to if$and properly

    OPQRSTU2Sobe ou Desce?Cargo Horas metasPontos3MantemComandante de exercitoAspirante 86935336381541176030Aspirante108693533638154117604MantemCapitao tenente2Tenente 869353363815411761352 Tenente208693533638154117615MantemMajor1Tenente 869353363823816714401...
  5. D

    Automatic Email Generation

    Greetings, I have a PO log sheet in excel. I want this excel sheet to automatically e-mail a user a list of open PO's, as long as conditions are met. The sheet has many columns, but of importance is column A, column C, Column O, and Column Q. In column A, the date the PO was submitted is...
  6. E

    Dragging formula along columns with changing reference cells

    Hi, I wrote the following formulas in Cell B2, C2 and D2 of Sheet 2: B2: =IF(AND(Sheet1!T2<20160000;Sheet1!U2>20150000);Sheet1!V2;"No") C2: =IF(AND(Sheet1!X2<20160000;Sheet1!Y2>20150000);Sheet1!Z2;"No") D2: =IF(AND(Sheet1!AB2<20160000;Sheet1!AC2>20150000);Sheet1!AD2;"No") I want to drag this...
  7. J

    Help need with if statement for acceptance criteria

    Hi, I need help with an if statements as I have tried a couple of things now and I just keep getting errors. I have a table (see image) and its in regards to an acceptance criteria. I need the formula outcome to state accept or reject. I have also uploaded a screenshot of the acceptance...
  8. lmmay

    IF and LOOKUP statements

    I have a workbook with a Labor/Equipment sheet. The sheet has dropdown menus for Employee, Title, Status (FT, PT, T) and Equipment. Labor costs are calculated based on work categories (A, B, C – G). Full time employee regular labor costs are not calculated for categories C – G. Part Time and...
  9. J

    IF(AND with IF(OR

    Trying to nail the syntax for: IF(OR(A1="TRUE", B1="TRUE", C1="TRUE" Return "TRUE" elseIF(AND(A1="FALSE", B1="FALSE", C1="FALSE" Return "FALSE" else "Unknown"
  10. O

    Multiple IF(AND

    Hi all, I currently have a table with a with multiple drop down lists with the option "yes" or "No". I'm looking to find out everytime "yes" is selected 25 will be added to cell M6(where the formula currently is). I'm looking to do this so i can use a data bar to measure progress. I've tried...
  11. P

    IF(AND function with Blanks

    Hi, Hope you can help me? I am using the below string and it is giving me most of the answer, however I want it to be blank if either R13 or S13 are blank...
  12. C

    Excel VBA AND <>

    Hey all I have some code that hides rows if a value in a column is = "TERMDT" which works great... But I am trying to get some working that has a few criteria What they asked for is "IF column Z (new status) is W, hide/remove UNLESS column D (BDCA code) is MMJ, MBJ, MNN, MBN, MML, MMP " The...
  13. W

    If/AND/SUM function with multiple cells and criteria

    Hi, I am trying to sum up 3 cells. This issue is I want to have them sum when specific text is added into two other cells. Here is the formula I have tried. =IF($AJ6="M",SUM($AG6:$AH6),IF($AJ6="B",SUM($AF6-($AF6*0.2), $AG6:$AH6), IF(AND(AI6="P",$AI6="N",$AI6="B",$AJ6="M"), SUM($AG6:$AH6,500)...
  14. P

    If(And formula yields three values - shouldn't it be two?

    First time posting...advanced beginner level skills. Currently working on data set of 5000 lines/month and I'll need to aggregate at least 4 months in each file. Here's what i'm trying to flag with as simple a formula as possible: If there is no change in column A in consecutive rows, and...
  15. A

    Multiple Criteria with TextJoin

    Hi all, I was wondering if anyone knows if you can use IfAnd statement within a TExtjoin to set multiple criteria. I have been able to use If statements but i am unable to get a ifand Statement to work. {=TEXTJOIN(CHAR(10),1,IF(AND(B4:B15=F16,H4:H14=D17),K4:K14,""))}
  16. B

    If(and( & n/a

    I am having trouble getting an IF)AND statement to work =IF(AND(J12=5,K12="Y"),"5Y",J12) In cell J12, value can be 1 to 5 in cell K12 I have a match formula referencing another cell so either Y or #N/A is returned. so I was hopng that if J12 =5 and K12 = Y then 5Y is displayed, otherwise just...
  17. J

    IF(AND statement works - changing to an IF( and IF(OR causes a False - also is there a better way to do this

    Based on an alpha value in A3 and a selection from a drop down in I3 (NO, FULL, PART), I want a numeric value placed in K3. I have this working until I change my IF(AND to an IF(OR and IF(. The first example works and the second one returns a false on the red line when PART is selected (FULL...
  18. J

    if statement with vlookup - returning false

    I have 3 different conditions and I am trying to use vlookup. Only the 1st if(and statement works. The 2nd and 3rd if(and return FALSE from the vlookup (***note each if(and statement works by its self***). Can I use if(and vlookup with the statements below?. The 2nd set of code works...
  19. T

    If(AND with multiply

    I am familiar with this type of IF(AND =IF(AND(G11=10,H11=20),"Yes","No") Can someone please explain what this is doing? =IF(AND(A1="a")*(B1=10)*(C1=30),D1,E50) What is the significance of the multiply? Thanks
  20. J

    Help with IF / And / OR

    I am not sure that I'm using the most efficient approach to what I'm trying to achieve. Input and advice is most welcome. I'm sure this is a simple formula, but I'm not having and success with it. <tbody> IF(AND( A1 > 9, and < 20, and B1 = "PHONE"), (DO THIS) </tbody> <tbody>...

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
Back
Top