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.

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

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.