megera716
Board Regular
- Joined
- Jan 3, 2013
- Messages
- 142
- Office Version
- 365
- Platform
- Windows
I have 3 columns of data with my formula in column 4. If any of the 3 columns are blank, I want the formula to return 0. If all 3 have data, then it should return 50.
Here's my formula, which I am doing as an array: {=IF(ISBLANK(Table1[@[1]:[3]]),"","50")}. But on the row in red text, it is returning 50 even though column 3 is blank (and yes, it is completely blank, not a formula returning a blank).
<tbody>
</tbody>
Here's my formula, which I am doing as an array: {=IF(ISBLANK(Table1[@[1]:[3]]),"","50")}. But on the row in red text, it is returning 50 even though column 3 is blank (and yes, it is completely blank, not a formula returning a blank).
1 | 2 | 3 | 4 |
01/23/2018 | 01/26/2018 | X | 50 |
X | |||
X | |||
01/25/2018 | 01/26/2018 | X | 50 |
X | |||
01/24/2018 | 01/24/2018 | 50 | |
01/15/2018 | 01/26/2018 | X | 50 |
01/25/2018 | 01/26/2018 | X | 50 |
<tbody>
</tbody>
Last edited: