Apr 15 2022 08:40 AM
I am working on an on-time delivery tracker and I am struggling with a formula to return a blank cell value if another cell is blank. Cell L3 and M3 are dates with L3 being the due date and M3 being the actual completed date. Cell P3 will tell me Yes or No (on time) based on due date and actual completed date (Cell L3 and M3). My formula is currently written as =if(M3>L3, "No", "Yes") but cell P3 still shows Yes even if dates are not entered in cell L3 and M3. How can I get cell P3 to be blank if cell L3 and M3 are blank (do not have dates)?
Apr 15 2022 08:57 AM
Apr 15 2022 09:04 AM
=IF(OR(L3:M3=""),"",IF(M3>L3,"No","Yes"))
Apr 15 2022 09:53 AM
Apr 15 2022 09:54 AM