Related:
- Removing a returned value of FALSE in Excel
- Number to words in excel - Guide
- Screenshot in excel - Guide
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
- If cell contains text then return value multiple conditions ✓ - Excel Forum
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