Amend incorrect formula on Excel 2003 Workbook
- or -
Post a project like this3657
£80(approx. $101)
- Posted:
- Proposals: 6
- Remote
- #456394
- Awarded
Excel Expert, Excel Spreadsheets, Excel VBA & Access Database Developer, Data modelling & Analysis
London
SENIOR WEB DESIGNER/ANIMATION/Portuguese Translator/FRENCH TRANSLATOR/GERMAN TRANSLATOR
Mumbai
9032735495128156555014579452645863
Description
Experience Level: Intermediate
General information for the business: Excel Software for Accountants
Description of requirements/functionality: We have an Excel 2003 Workbook which has various formulas in. One of the formulas in not working correctly when certain data is entered.
The Workbook has a data sheet which a number of columns to enter figures in. One of them is Savings Net. When you enter between 2001 and 5000 the formula does not calculate this correctly. Any figures below 2001 or over 5000 works fine. This Workbook is used by Accountants and Tax Managers.
We are looking for somebody who is very good/an expert at working with Excel Formulas no accountancy background is required but helpful if you have this.
I have attached a pdf to give you an idea of the job. The first page is the report which i have highlighted the error, the second page is the rates sheet which has all the formulas in and again i have highlighted where the error is. Finally the last sheet is just 2 of the formulas taken from the rates sheet so you can see how these have been put together.
Due to security and confidentially of the software i cannot load this up for you to look at. If you need to look at this workbook a NDA would have to be signed first.
This is quite an urgent job and ideally we would like this to be completed by Monday 7 April if possible.
This is only a very brief description of the issue so i am happy to explain further or answer any questions you may have.
Extra notes:
Description of requirements/functionality: We have an Excel 2003 Workbook which has various formulas in. One of the formulas in not working correctly when certain data is entered.
The Workbook has a data sheet which a number of columns to enter figures in. One of them is Savings Net. When you enter between 2001 and 5000 the formula does not calculate this correctly. Any figures below 2001 or over 5000 works fine. This Workbook is used by Accountants and Tax Managers.
We are looking for somebody who is very good/an expert at working with Excel Formulas no accountancy background is required but helpful if you have this.
I have attached a pdf to give you an idea of the job. The first page is the report which i have highlighted the error, the second page is the rates sheet which has all the formulas in and again i have highlighted where the error is. Finally the last sheet is just 2 of the formulas taken from the rates sheet so you can see how these have been put together.
Due to security and confidentially of the software i cannot load this up for you to look at. If you need to look at this workbook a NDA would have to be signed first.
This is quite an urgent job and ideally we would like this to be completed by Monday 7 April if possible.
This is only a very brief description of the issue so i am happy to explain further or answer any questions you may have.
Extra notes:
Kay H.
99% (19)Projects Completed
18
Freelancers worked with
14
Projects awarded
53%
Last project
10 Apr 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 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