I need help on an Excel conditional formatting issue

£10-20 GBP

Terminado

Publicado

hace alrededor de 4 años

£10-20 GBP

Pagado a la entrega

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

ID del proyecto: 24101482

Información sobre el proyecto

9 propuestas

Proyecto remoto

Activo hace 4 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@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 en 1 día

5,0

(6 comentarios)

2,8

9 freelancers están ofertando un promedio de £22 GBP por este trabajo

@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 en 1 día

4,7

(173 comentarios)

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 en 1 día

4,7

(15 comentarios)

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 en 1 día

5,0

(28 comentarios)

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 en 1 día

3,9

(16 comentarios)

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 en 3 días