Find Jobs
Hire Freelancers

Excel - Simple task.

₹750-1250 INR / hour

Fechado
Publicado há 5 meses

₹750-1250 INR / hour

I have a table with hundreds of entries. I need to add .03, 04 or .05 cents to certain columns. So it will turn the amount from .16 to .19, .20, or .21 It is tedious to go thru hundreds of cells to do this. Is there a way to do it with a formula?
ID do Projeto: 37537855

Sobre o projeto

56 propostas
Projeto remoto
Ativo há 4 meses

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
56 freelancers estão ofertando em média ₹936 INR/hora for esse trabalho
Avatar do Usuário
Hi, Yes it is possible with VBA and Formula. I can develop Excel VBA Macro to automate your tedious job as per your requirements. I am an experienced Data Analyst and Macro Developer and have done many similar projects. So, can do this job nicely. Ready to start please message me to discuss your project in more detail. Thanks, Virendra
₹1.250 INR em 40 dias
4,8 (153 avaliações)
6,2
6,2
Avatar do Usuário
Hello sir, I can do this work. can you explain complete detail? My priority is customer satisfaction. Please send Hi on chat so that we can discuss more. Thanks
₹1.000 INR em 40 dias
5,0 (1 avaliação)
5,4
5,4
Avatar do Usuário
Hello There, I understood your requirement of changing or adding . cent to certain price in excel. Please share excel file for me to update price for few rows for your review. Available and ready to start Regards Imran
₹1.000 INR em 40 dias
5,0 (78 avaliações)
5,4
5,4
Avatar do Usuário
Hi there! I understand that you need to add .03, 04, or .05 cents to certain columns so that the amount from .16 to .19, .20, or .21 can be changed to the desired value. However, I believe that I am the perfect person for this project. With my extensive experience in data entry and processing as well as excel, I am confident that I can provide you with the results you are looking for. I have worked on many projects similar to this one in the past, so you can rest assured that you will receive quality output delivered on time. Additionally, if you would like to discuss further any part of my services including Excel work or web research please feel free to contact me. Thank you!
₹750 INR em 40 dias
5,0 (22 avaliações)
4,9
4,9
Avatar do Usuário
I understand what you're looking to do with your project - adding .03, .04 or .05 cents to certain columns to turn the amount from .16 to .19, .20, or .21. This is a tedious task that needs to be done with a formula, but I have the skills and experience to help you get it done efficiently. My background in project management and data analysis make me the perfect person for this job. I have extensive experience managing projects of all sizes and scopes and have a proven ability to lead teams and deliver successful outcomes. My organizational skills and ability to communicate effectively with stakeholders make me an asset in any situation where complex projects are involved. Additionally, my data entry skills make me an ideal candidate for this job as they allow me to collect, clean, and analyze data effectively. I would be delighted to discuss this project further with you if given the chance! Please don't hesitate to reach out if you have any questions or would like more information about my skills/background.
₹1.000 INR em 40 dias
4,9 (7 avaliações)
4,9
4,9
Avatar do Usuário
Hi there! I am expert in MS-Excel and can easily do this project. Let me know if you are interested. Regards!
₹750 INR em 25 dias
5,0 (21 avaliações)
4,4
4,4
Avatar do Usuário
Hi, Total : 2500 Time : 1 Day (3-4 hrs) This can be automated suing power automate. I have read the requirement and understood, we can discuss more for detailed requirements. My Profile: 1. I have 13+ years of experience with with different SP versions -SP Online/2019/2016/2013/2010 2. I have 3+ years of experience with power platform Power automate, PowerApps. 3. Worked with Nintex Forms and flows 4. Experience with SPFx, ReactJS, JavaScript, jQuery, Typescript, REST Apis, Webhooks etc. Looking forward for your response. Regards, Shekhar
₹1.000 INR em 20 dias
5,0 (3 avaliações)
1,6
1,6
Avatar do Usuário
Hello there! Thank you for considering me for the job of adding .03, 04 or .05 cents to certain columns in Excel. I understand how tedious it can be to go through hundreds of cells to do this, so I am here to offer my skillset to help you complete this task. I am a good listener and I'm able to fulfill the task given remotely as I am still a degree student. I would love to have the job as it is able to work remotely. I have extensive data entry experience and excel skills which will come in handy for this project. If you give me the chance to work on this project, you can be sure that you won't be disappointed with the results! Please feel free to reach out with any questions or concerns you may have regarding this project.
₹1.000 INR em 40 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hello there! I'm Syeda Nayyab, a proficient web developer with a strong command of front-end and back-end technologies. I have extensive experience in Excel and specifically in creating formulas that add .03, .04 or .05 cents to certain columns, so it will turn the amount from .16 to .19, .20, or .21. I understand from your description that you need to add .03, .04 or .05 cents to certain columns in order to make them from .16 to .19, .20, or .21. This can be tedious to go through hundreds of cells, so I believe I could be the best fit for this project. I have experience in web development and specifically in creating responsive and visually appealing web applications. Additionally, I ensure optimal user experiences by implementing secure coding practices and database management into my projects.
₹850 INR em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Automating Data Modification in Your Google Sheet: Proposal Problem: Your Google Sheet contains hundreds of entries requiring manual addition of .03, .04, or .05 cents to specific columns. This process is time-consuming and prone to errors. Solution: I propose automating this data modification using two efficient methods: RANDBETWEEN and IF Functions: This formula uses random numbers to determine the appropriate modifier, adding .03, .04, or .05 cents automatically. VLOOKUP and Helper Table: This method creates a table defining modifiers for different values. VLOOKUP then matches each original value to its corresponding modifier in the table. Benefits: Save time and effort: Automates the modification process, freeing you for other tasks. Accuracy: Eliminates manual errors and ensures data consistency. Flexibility: Modify formulas for different cent ranges or decimal precision. Visual distinction: Use conditional formatting to easily identify modified values. Adaptability: Formulas adjust automatically when rows are added or deleted. Deliverables: Modified Google Sheet: Implemented with chosen method. Clear instructions and guidance: Easy-to-understand instructions for using the automation. Ongoing support: Available to answer any questions you may have.
₹1.000 INR em 40 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hello sir/madam! My name is Yesi, and I am the perfect person for your project. I has extensive experience in accurately copying large sizes the data volume of handwritten documents becomes specific software. Additionally, I have experience working with Excel sheets and other types of data. Additionally, my commitment to accuracy and care details make me an excellent choice for this job. I'm ready to start right away so no need to worry about deadlines or other constraints that affect our work together. If you are interested in my abilities, don't hesitate to get in touch so we can discuss further. Thank You, Yesi Amelia
₹800 INR em 40 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hello there! I am Rohmah, a data entry expert with extensive experience in Excel. I understand that you are looking for ways to add .03, .04 or .05 cents to certain columns, so that it will turn the amount from .16 to .19, .20 or .21. With my expertise in data entry and Excel, I am confident that I can provide the solution you are looking for. I have the necessary expertise to complete your project quickly and accurately. My skills include entering data into various formats and languages as well as using formulas to achieve specific results quickly and efficiently. This makes me the perfect fit for this job as I can complete the task quickly and accurately with little effort required on your part. If you decide to hire me for this project please don't hesitate to reach out with any questions or concerns you may have about my profile or services. Thank you for your consideration!
₹850 INR em 40 dias
5,0 (1 avaliação)
0,0
0,0
Avatar do Usuário
I can process and analyze information quickly, which can help expedite data entry tasks. This can be especially useful for handling large datasets or repetitive tasks. I can process and analyze information quickly, which can help expedite data entry tasks. This can be especially useful for handling large datasets or repetitive tasks. I can process and analyze information quickly, which can help expedite data entry tasks. This can be especially useful for handling large datasets or repetitive tasks. I can assist in various data-related tasks, such as organizing data, performing calculations, and generating reports. My versatility allows for a wide range of applications in data entry.
₹750 INR em 40 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
By using basic logic formulas we can add cents to perticular column to you with given condition you can use the same sheet and forumals for another data or next sheets also
₹1.000 INR em 40 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
if you have a condition where you want to add 0.03 to amounts less than 0.16, 0.04 to amounts between 0.16 and 0.20, and 0.05 to amounts greater than 0.20, you can use nested IF statements: =IF(A1<0.16, A1+0.03, IF(A1<=0.20, A1+0.04, A1+0.05))
₹1.000 INR em 40 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hi Dear sir, I read your post thoroughly and I surely want to say that I can deliver your workout on time and you will be satisfied by me.
₹750 INR em 50 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Dear sir, This is very simple I can give you formula and also I can guide on this project.
₹1.000 INR em 40 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hi, I understand that you need to add .03, 04, or .05 cents to certain columns so that the amount from .16 to .19, .20, or .21 can be changed to the desired value. However, I believe that I am the perfect person for this project. With my extensive experience in data entry and processing as well as in excel, I am confident that I can provide you with the results you are looking for. Thank you.!!!
₹750 INR em 40 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hello, I am a highly skilled and detail-oriented data entry specialist with a proven track record of delivering accurate and efficient results. I am enthusiastic about the opportunity to contribute to your project and ensure the highest quality of data entry. Services Offered: * Fast and accurate data entry *Data cleaning and validation *Spreadsheet organization and management *Attention to detail in every task *Timely delivery of completed work Why Choose Me: * 2 Years of experience in data entry * Commitment to meeting deadlines * Excellent attention to detail *Strong communication skills I am confident in my ability to deliver exceptional results for your project. Let's discuss your specific requirements and how I can best assist you. Looking forward to the opportunity to contribute to your success. Best regards, [Rajeev ranjan pathak]
₹800 INR em 30 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
yes I'm ready to do your work and I'm expert in data entry in excal on CA office please give me a one chance my gmail is and whtsapp no is 8219307319
₹1.000 INR em 40 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) INDIA
Kurukshetra, India
0,0
0
Membro desde nov. 6, 2023

Verificação do Cliente

Outros trabalhos deste cliente

Copy Typing
₹12500-37500 INR
Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.