Column E is Blank
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.
I am in need of some help with a hard IF/AND Statement with multiple variables
My current Formula:
T$4 = is my header date (Formula is dragged left to right in the same row
$J9 = My Starting Date...
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.
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...
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...
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:
1984-2002 – Millennial
1946-1964 – Baby Boomers
1965-1983 – Gen X
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
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:
formula to try and help me sort out the problem...
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"
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"...
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...
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...
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.
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?
Given the following snippet of a database:
I would like to automatically fill in the "#" and "max dy" columns as...
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.