Learn how to work around a couple bugs in Excel to return double values; drill down on lists with anonymous types; and learn the difference between Build and Rebuild.

For showing a 0 value in place of error, use =IFERROR(B2/C2,0) You can also use an IF statement like =IF(C2=0,0,B2/C2) to get 0 return value in case C2 contains a zero.

The Excel ISBLANK function returns TRUE if cell value is blank and False if the cell is not blank, and it is also an information function.

Learn how to combine Microsoft Excel’s ROW() and ROUNDUP() functions to create a flexible serial function that returns groups of consecutive values.