Related:
- Removing a returned value of FALSE in Excel
- Gif in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Marksheet in excel - Guide
- Kernel for excel - Download - Backup and recovery
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