Can you use Isblank on a range?
Photo Credit: Courtesy of 3DStockPhoto (Can you pawn shoes? image)
There is no need for an IF function, simply use the ISBLANK function and then multiply with the corresponding cell range. The ISBLANK function returns TRUE or FALSE determined by if cell is blank or not. Since we are using a cell range the ISBLANK function returns an array with the same size as the cell range.