Forum Discussion
Kat_000
Apr 15, 2022Copper Contributor
Blank Cell if another cell is blank
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 ...
HansVogelaar
Apr 15, 2022MVP
=IF(OR(L3:M3=""),"",IF(M3>L3,"No","Yes"))
Kat_000
Apr 15, 2022Copper Contributor
Thank you so much. Really helpful, Now I see the mistake I made with the OR function