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...