Removing a returned value of FALSE in Excel [Closed]

 Blocked Profile -

Here is my formula. Please tell me how I can eliminate the FALSE value for cells that don't fall within the date range (e.g. cells with dates that start prior to the date listed in EF13).


1 reply

Ok, well you have nested ifs, and didn't give the second false statment. Consider your example:

Now take a look at this:

I hope that helps!
It's kind of fun to do the impossible! -Walter Elias Disney

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!