ifand

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

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

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

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

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

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

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

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

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"

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

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

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

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

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

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,""))}

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

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

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

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

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