Excel Expert Needed to Troubleshoot Percentage Calculation Issue

Job ID: 38130178

Budget: $10 – $11 CAD

I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem.

Details:

I am working with the following data in my spreadsheet:

Total Costs for the Job (Cell V14): $241,779.50
Total Collected (Cell V17): $289,844.00
Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50
I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is:

=
(
?
15
/
?
14
)

100
=(V15/V14)∗100
Given the values:

=
(
48
,
064.50
/
241
,
779.50
)

100
=
19.88
%
=(48,064.50/241,779.50)∗100=19.88%
However, instead of getting 19.88%, the result I am seeing is 1987.95%. This suggests there might be an error with the data, cell formatting, or an unnoticed issue in the spreadsheet.

Specific Tasks:

Review the Spreadsheet: Analyze the provided Excel file to ensure all values, formulas, and cell references are correct.
Identify the Issue: Determine why the formula results in 1987.95% instead of the expected 19.88%.
Correct the Calculation: Fix the formula or any underlying issues to display the correct profit percentage.
Provide Documentation: Explain the issue and the steps taken to resolve it, so I can avoid similar issues in the future.
Requirements:

Proficiency in Microsoft Excel, including advanced formula creation and troubleshooting.
Experience with data validation and formatting.
Ability to communicate effectively and provide clear documentation.
If you are confident in your Excel skills and can help solve this issue, please apply with your relevant experience and availability.