Jayjayjayccc
New Member
- Joined
- Apr 18, 2022
- Messages
- 1
- Platform
- Windows
Hi, I am trying to get a return value of GOAL MET vs NOT MET depending on a set of conditions. Here's the formula that I have typed up, but it seems to have problems with it:
=IF(D2<=(-- 15:00) AND I2=DATE(D2) OR D2>=(-- 15:00) AND I2<=(DATE(D2)+1),"Met","NOT Met")
Colume D and I both have date/time: 4/18/2022 03:00 AM
Basically, here are my conditions typed up in plain english:
If Column D has a time on or before 3pm, AND column I has the same date as column D, GOAL MET.
If Column D has a time after 3pm, AND column I has the same date or the day after column D, NOT MET.
Thank you for helping me!
=IF(D2<=(-- 15:00) AND I2=DATE(D2) OR D2>=(-- 15:00) AND I2<=(DATE(D2)+1),"Met","NOT Met")
Colume D and I both have date/time: 4/18/2022 03:00 AM
Basically, here are my conditions typed up in plain english:
If Column D has a time on or before 3pm, AND column I has the same date as column D, GOAL MET.
If Column D has a time after 3pm, AND column I has the same date or the day after column D, NOT MET.
Thank you for helping me!