Related:
- Removing a returned value of FALSE in Excel
- Number to words in excel - Guide
- How to take screenshot in excel - Guide
- Dd-mm-yyyy format in excel - Guide
- Excel free download - Download - Spreadsheets
- Excel marksheet - Guide
1 response
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
=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
