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.

When you think of double quotation marks, you probably remember your English lessons in school. However, in Microsoft Excel, ...

Excel SPILL errors occur when a formula returns multiple results. Learn how to fix #SPILL formula errors in Microsoft Excel.

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.

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