Fix formula errors in spreadsheet
- or -
Post a project like this835
$$
- Posted:
- Proposals: 3
- Remote
- #2237181
- Awarded
Description
Experience Level: Intermediate
I've attached a spreadsheet that I need fixed. I need the following done;
1) Cells AS 4-99: I need to add $2 to the value that's reflected in column AM
2) Cells AS 109-179: I need to add $1 to the value that's reflected in column AM
3) Cells AV 4-99: I need to add $1 to the value that's reflected in column AP
4) Column AV 109-179: I need to add $.50 to the value that's reflected in column AP
5) Fix the #DIV/0 in the 5-Year Average and 2019 Pricing Matrix Columns
6) Make sure the totals at the bottom match up to the totals above.
If you just do this in the April worksheet I can copy and paste this to the remaining worksheets,
1) Cells AS 4-99: I need to add $2 to the value that's reflected in column AM
2) Cells AS 109-179: I need to add $1 to the value that's reflected in column AM
3) Cells AV 4-99: I need to add $1 to the value that's reflected in column AP
4) Column AV 109-179: I need to add $.50 to the value that's reflected in column AP
5) Fix the #DIV/0 in the 5-Year Average and 2019 Pricing Matrix Columns
6) Make sure the totals at the bottom match up to the totals above.
If you just do this in the April worksheet I can copy and paste this to the remaining worksheets,

Steve B.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
10 Dec 2018
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We use cookies to improve your experience and our services. By using PeoplePerHour, you agree to ourCookie Policy