if and

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

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

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

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

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

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

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

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

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

Hi all, I hope you can help me. I am trying to get a yes / no value in the current conditions. I need to get a yes if the date (H2) is 8 months or over and equal to or under 12 months of the date(F2)and a no if the date (H2) is over 12 months. I currently have this on the go but I'm getting...

Dear All, I have a sheet in which basically three columns , Available License Type, Required License Type, Status. If Available License Type = “Light” and Required License Type = “Light” Then in the Status column result should be “Match” If Available License Type = “Light” and Required License...

I am currently struggling with a formula I have in my excel. There is a number in cell F11 that is between 1 and 5 (it varies based on the information entered). I am trying to write a formula that will say if the number is less than 2, then say Bronze. If it is 2-3, then say Silver. If it is 3-4...

Hi, Im trying to use an "if then" statement to show if a number is larger than 2% of 1,500,000 or smaller than 2% 1,500,000 then FALSE, if in-between the rage then TRUE. In other words, if number is within the range of 2% of X - the statement is TRUE and if outside then FALSE. Any...

=C13+IF(AND(Input!B17<(Input!B5*(Input!B6/12*(MonthsOpen-1)))),C11>C13,C11-C13,0) This is my first time using excel's IF AND statements. Can anyone tell me what is wrong with this formula without looking at the actual data? Thank you

Given the following snippet of a database: <tbody> sample # XDAT Horiz dy # max dy 1446 211 201.2 98 1447 211 202.2 68 1448 211 203.0 50 1614 200 135 40 1615 200 136 45 1616 200 130 35 </tbody> I would like to automatically fill in the "#" and "max dy" columns as...

Hi, I am trying to count data from Table 1, in Table 2 - but I need to only CountIF the cell contains the specific text (FRED,GEORGE etc.) AND a specific colour as shown. Table 1 <tbody> *RED* *GREEN* 1:00pm FRED GEORGE 2:00pm DAVE DAVE </tbody> Table 2 <tbody> *RED* *GREEN* FRED...

So I really need help with this one here. Column H needs to reflect how many points you're over or under based on several criteria. Currently, I have column F setup as follows: =IF(D8="Excellent","$99",IF(D8="Pass","$99",IF(D8="Mid","$198",""))) The ideal setup is 9 in column g, Y in columns...

Hi all, I have a multiple IFs condition formula which works fine below: =IF(AND(I200="",J200="",K200=""),"N",IF(AND(G200<today(),h200<>"Complete"),"Forecast End Date is before current date - Status needs to be Complete or Date needs to be updated. Note: Status also cannot be...

This is a rookie question but I have searched several Knowledge Bases/Blogs and have not yielded any results that were helpful. I am trying to write a programming statement to achieve the following: I am checking 2 different cells looking for specific data and then posting results based on...

I have a workbook where people regularly populate if they have done a task for that week or not. I'm building a "compliance" sheet that will capture the overall % of completed tasks. The trouble is getting the blank cells to produce the word "Blank". I DO NOT want the number zero produced for...