IF function and returning a blank cell
Hi!
I've tried several different versions of this function and haven't had any luck so far getting it to work. I want the function to return Yes, No, or stay blank as a way to indicate whether tasks were completed on time. Yes means the task was completed on time, No means the task was late, and blank means the task hasn't been completed yet.
I got the Yes/No part to work, but can't figure out how to get the function to return a blank cell. Here's what I have so far:
This part works on its own: =IF([Completion Date]22 <= [Due Date]22, "Yes", "No")
Here's where I'm struggling: =IF([Completion Date]21 <= [Due Date]21, "Yes", "No"), IF(ISBLANK([Completion Date]21), ""))
I think I need to use the ISBLANK function, but not positive. It seems like there's an easy fix that I'm just not seeing. I've also tried "0" and <>"" in place of the "".
Thanks for any help!
Answers
-
=IF(ISBLANK([Completion Date]21), "", IF([Completion Date]21 <= [Due Date]21, "Yes", "No"
-
Thank you!!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!