I need help on an Excel conditional formatting issue

£10-20 GBP

Completed

Posted

about 4 years ago

£10-20 GBP

Paid on delivery

I am an agent representing developers who offer investments with varying percentage returns depending on the amount invested. I have designed a calculator to illustrate these investor returns. Because there are different percentage returns for four levels of investment I currently have four different tabs. What I am trying to do is combine the four tabs into one. What I want to happen is for three cells in the table to change percentage as the single investment amount cell is entered. For example when a figure up to £99,999 is entered, three cells for the first three years of investment will show 8%, 9% and 9% for the third year. When £100,000 to £124,999 is entered the three cells need to be 9%, 9.50% and 9.50%. And so on for two more brackets of investment level. The amount invested is in cell G6. Three cells that need to change are D9, D10 and D11

Project ID: 24101482

About the project

9 proposals

Remote project

Active 4 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@Salmandaud

Dear, I am an expert in MS Excel with more than 10 year of experience. I have reviewed your attached sheet and can amend the Calculator using only one sheet only. work can be deliver within 30 mins. Regards

£12 GBP in 1 day

5.0

(6 reviews)

2.8

9 freelancers are bidding on average £22 GBP for this job

@khurram1984

"Hi. i am an affiliate chartered accountant (CPA) and a professional finance expert since 2009. We have worked with our clients at national as well as international level. We have advanced knowledge in excel because of extensive financial background, expertise and experience. We know how to prepare good dashboards, reports, templates which require minimum input from staff and must be automated. i am a professional business expert since 2009 and good understanding how to present information with attractive outlook. Kindly share your details of the project and insights of your requirements. We can address all your requirements with quality."

£50 GBP in 1 day

4.7

(173 reviews)

6.8

@syedomairali

"Dear Sir, I am a CPA and have a firm established in Pakistan. i am an excel expert, have advanced level knowledge and prepared numerous reports, dashboards, templates, formats for my clients based on their specific requirements. I can share my sample work as well for your review. Please have a look at my portfolio to see my sample work. I can deliver your work within 2 - 3 days with good quality. we can discuss the details of your requirements so that they can be addressed properly. Please text me. Thanks! Omair "

£30 GBP in 1 day

4.7

(15 reviews)

4.3

@merinsinha

■Hi i am an expert in these■ For Professional works -Hire me. As 10+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platfrom give me a chance to show you the best i can do at your service.

£23 GBP in 1 day

5.0

(28 reviews)

4.0

@Amrsamra

Hello I`m CMA holder and financial analysis. i created many financial proposals and financial plans can you msg me please to discuss more details ty

£15 GBP in 1 day

3.9

(16 reviews)

3.6

@qlzfelipe

Hello, I'm an Excel professional and have done very similar works recently. Message me and let's get this done for you. If there is anything you want to add about the formatting beyond the description, just tell me. Thanks!

£17 GBP in 3 days