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].
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.
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?
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.
I am attempting to create a formula in B6 that considers the following criteria:
If SUM B1:B2 <100
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 <...
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...
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...
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"...