The error code
1E+05 in Excel usually means that the result of your calculation is too large to be displayed in the cell. In other words, the number is too big for the cell to handle.
To fix this issue, you can try
increasing the width of the cell or changing the format of the cell to
scientific notation. Here's how you can do it:
- Select the cell that is displaying the error code.
- Right-click on the cell and select "Format Cells".
- In the Format Cells dialog box, select the "Number" tab.
- Under "Category", select "Scientific".
- In the "Decimal places" field, enter the number of decimal places you want to display.
- Click "OK" to apply the changes.
If changing the format of the cell doesn't work, you can try
breaking down the calculation into smaller parts and then adding them together. This can help to avoid the error code and give you the correct result.