Excel Expert

Completed Posted 3 years ago Paid on delivery
Completed Paid on delivery

Purpose:

An upholsterer who refurbishes antiquities ordinarily charges £100 to refurbish a small sofa and £300 for a large sofa but offers some discounts on the total cost as detailed below.

For small sofas, the discounts are:

1 small sofa 0%.

2 small sofas 7.5%.

3 small sofas 10%.

More than three small sofas 12%.

For large sofas, the discounts are:

1 large sofa 15%.

More than 1 large sofa 18%.

Write a program, which upon receiving information from the customer about the number of items they want refurbished, informs them how much it will cost.

The routine must:

• allow the customer to enter the number of each type of sofa they would like refurbished.

• ensure input data are valid, e.g. ensure that numbers are non-negative.

• display appropriate error messages (e.g. through MsgBox).

• calculate and then display the cost (e.g. through MsgBox).

Once you have successfully completed the basic routine as specified above, work on extending its flexibility and range of usage. Extensions could include, but not limited to, the following considerations:

• How can data entry be made simple and straightforward for the user? Is the routine flexible enough to accept data of different formats?

• Can the routine be extended for other purposes such as, for example, as an integral component of a larger application such as one that might be used by a larger workshop with larger numbers of customers?

• And so on.

we need

An Excel file in xlsm format containing your routine.

A single pdf document containing the text of your VBA routine.

Excel VBA Excel

Project ID: #28319777

About the project

14 proposals Remote project Active 3 years ago

Awarded to:

(55 Reviews)
4.9

14 freelancers are bidding on average €25 for this job

AnowarRatul

Hello Sir I am an expert on Excel I am available right now I can do this job please knock me......... Thanks Anowar

€25 EUR in 1 day
(201 Reviews)
6.1
akritisood94

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me.

€30 EUR in 1 day
(71 Reviews)
5.6
zu02

Hello I hope all's well with you. I see you're looking for a developer proficient in Ms Excel/VBA. I'm professional Ms Access/Excel/vba coder. I'm coding in vba since Ms Office 97 released. Please visit (where I'm w More

€19 EUR in 7 days
(22 Reviews)
5.4
rIbrarahmed

hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myse More

€19 EUR in 1 day
(22 Reviews)
4.9
Emmyope93

Hi, Good day. I understand you need a good work done in Excel. I will like to assist you on this project. I have delivered similar projects here on freelancer and can share sample of my work with you. A Little More Ab More

€27 EUR in 2 days
(4 Reviews)
3.2
PoojaGupta002

I can perfectly help you with that. I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Google sheets & Excel (including VBA and Macro) to per More

€15 EUR in 1 day
(1 Review)
1.3
faizanmaqbool695

I can complete your project on time and within your budget. I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. I can achieve the results that you are askin More

€30 EUR in 1 day
(0 Reviews)
0.0
ansermehmood029

Hay Dear, I Understand you are looking for a well experienced excel work for your projects.  I have more than 6 years of experience of Data Entry, Excel sheets Data Management, and account  Management. I have done t More

€19 EUR in 7 days
(0 Reviews)
0.0
robinsammi32

Greetings . I hope you had a very nice day. I am willing to work tirelessly to satisfy you in a twenty four hour period. I am avid at excel and hope that I am your choice for the job. Thank you in advance.

€27 EUR in 7 days
(0 Reviews)
0.0