Fix Excel Spreadsheet Weighted Averages Formulas
- or -
Post a project like this2418
$$$
- Posted:
- Proposals: 5
- Remote
- #1691370
- Completed
Description
Experience Level: Expert
Description of excel work: Need to correct formulas for weighted averages in excel. Sheet attached excel file. In row 15 for heading Suggested Rate Raw Number, the formula is not calculating the correct fields. The formula is supposed to calculate the weighted average of the competitor's rates weighing how important each competitor is (column b) after calculating how higher or lower the rate should be compared to the competitor (column a).
Extra notes:
Extra notes:
Jon H.
100% (10)Projects Completed
19
Freelancers worked with
15
Projects awarded
48%
Last project
20 May 2021
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Jon
Can you share the correct formula? -
Hello,
Can you share the Formula using Cell Addresses?
Best Regards,
Chanaka
489579489532
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies