#1
|
|||
|
|||
IF(AND()) data not populating
I want to have an "x" in rows where the criteria between two data fields is met (based on quarters). I'm using an IF/AND statement. =IF(AND(A2>9/30/22,B2<1/1/2023),"X"," ") If Column A is >9/30/2022 and Column B is < 1/1/2023, an "x" should be added, if not the column is blank. This worked the first time I tried it, but I had an issue with the formula not correctly filling down the column; trying this again, the formula is correct in the rows, but "X's are not being populated. The format in A & B show they are set in a date format. Any ideas on what I'm doing wrong? I've attached an abbreviated spreadsheet showing what I have. |
#2
|
||||
|
||||
After trying in C2 =IF(AND($A2>DATEVALUE("30/09/2022"),$B2<DATEVALUE("1/1/2023")),"X"," ") and pulling down
( with my regional settings which are different), no "x" is returned. So I checked manually and none of yoyr dates match the given conditions ( of course they do match when there is an empty cell in col B) Try the same formula type in the other columns |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Capturing Data and Populating Word Templates | derekb | Word | 2 | 08-12-2019 12:22 AM |
Populating Tables with data when available only - Using Mail merge | stevejohhnym | Mail Merge | 1 | 06-25-2019 12:50 AM |
Auto Populating Data with Drop Down Menu | vmangano | Excel | 4 | 12-20-2016 09:03 AM |
Populating data From one sheet to another, relative rows | mmp | Excel | 16 | 02-08-2016 09:06 AM |
Populating Data in New TABs? | Sueade | Excel | 2 | 06-02-2015 09:12 PM |