Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-26-2021, 07:36 AM
NLJ NLJ is offline IF(AND()) data not populating Windows 10 IF(AND()) data not populating Office 2016
Novice
IF(AND()) data not populating
 
Join Date: Jan 2020
Posts: 4
NLJ is on a distinguished road
Default 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.
Attached Files
File Type: xlsx Assignment Test.xlsx (50.7 KB, 2 views)
Reply With Quote
  #2  
Old 09-26-2021, 07:58 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline IF(AND()) data not populating Windows 7 64bit IF(AND()) data not populating Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,480
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

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
Reply With Quote
Reply

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
IF(AND()) data not populating 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:43 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft