How to Insert a Formula on Report Exported Excel File .
How to Insert a Formula on Report Exported Excel File?
Follow the below steps to insert a formula in the report exported as an Excel file:
You can only insert a formula to get the sum of all the entries in a certain column once the values in this column are converted as numbers.
- Once the report has been exported as an Excel file, make sure that editing is enabled. Scroll to the column where you want to add a formula.
- Highlight the entries that are needed for the formula.
- Once the entries are highlighted, click on the 'i' icon and click on 'Convert to Number'.
- Since the entry values have met the requirement, you can now add/ create a formula in Excel for the said column/entries.