Removing a returned value of FALSE in Excel

CG - May 11, 2016 at 04:37 PM
 Blocked Profile - May 11, 2016 at 05:39 PM

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 response

Blocked Profile
May 11, 2016 at 05:39 PM
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