Previous Topic Next Topic

Removing a returned value of FALSE in Excel

Closed
CG - May 11, 2016 at 04:37 PM
 Blocked Profile - May 11, 2016 at 05:39 PM
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))

Related:

1 response

Answer 1 / 1
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:
=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
0

Similar discussions

Can't remove threat with Windows Defender
Babarali4 -
ravida_1351 -

2 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses