Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Also, the error message is because there currently isn't any data, so Excel is throwing a 'Divide by 0' error. This will not be in the output file because the file will contain data.

...

titleUsing Data Sheets

...

Referencing the data sheet with number formats

1. Select C4 on Sheet1.

2. Start to type the formula by entering =(

...