Removing a returned value of FALSE in Excel

Closed
Report
-
 Blocked Profile -
Hello,

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).

=IF(EF$13>=$E17,IF(EF$13<=$F17,$D17))

1 reply


Ok, well you have nested ifs, and didn't give the second false statment. Consider your example:
=IF(EF$13>=$E17,IF(EF$13<=$F17,$D17))

Now take a look at this:
=IF(EF$13>=$E17,IF(EF$13<=$F17,$D17,WhatValueIfThisIsFalse),WhatValueIfThisIsFalse)


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