75 Essential Excel tips

As with any Excel formula, you can use the autofill feature to copy natural language formulas. In this case, to avoid a Division By Zero error, before copying, make the divisor absolute by selecting the divisor Total Sales and pressing [F4]. If you're using Excel 2002, the natural language formula … ................
................