Find Jobs
Hire Freelancers

Spreadsheet pricelist : Round all prices up to ***9

$15-25 USD / hour

Terminado
Publicado hace más de 8 años

$15-25 USD / hour

Got a xls spreadsheet with different prices for 13000 products. Alot of the prices are ending with a 0, for example 490. All prices should be rounded up to the nearest 9. In this case 490 would be rounded up to 499. Prices with the correct ending, for example 3999, should remain unchanged. 1590 = 1599 490 = 499 1840=1849 495= 499 492= 499 1498 = 1499 34 = 39 29 = 29 39 = 39 14999= 14999 And so on. You should know how to automate this and I want to have the code from the automation, so we can do it ourself later on.
ID del proyecto: 8572199

Información sobre el proyecto

64 propuestas
Proyecto remoto
Activo hace 9 años

¿Buscas ganar dinero?

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:
Avatar del usuario
Dear Concerned... This is a simple program in Excel. I cannot bid for this .... I am giving you the Formula for free.. Check with your excel sheet ... if any doubts ... pls revert to me... =(CEILING(cell,10)-1) in above program replace the word cell with your raw data cell. With Regards JACIN - 9495217328 (india)
$22 USD en 1 día
5,0 (1 comentario)
0,7
0,7
64 freelancers están ofertando un promedio de $21 USD /hora por este trabajo
Avatar del usuario
Dear Sir/Ma'am, Price and duration will vary depending on actual project. I am a Web research and Data Entry expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can find and extract the information from different websites into an Excel sheet. I am ready to hear the details of the project more in detail now. I have always created a long-term collaboration with my clients through hard work and quality output for a reasonable price. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
$15 USD en 3 días
4,9 (476 comentarios)
8,2
8,2
Avatar del usuario
Hello Dear, I am an expert in Data Entry, Excel. I have over 5 years of experience. I can perfectly do it and interested for this project. I am waiting to your quick positive reply. Feel free ask me question if any.
$15 USD en 3 días
5,0 (496 comentarios)
7,9
7,9
Avatar del usuario
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.in/u/RSUKANTA2014.html I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sourabha Roy.
$15 USD en 62 días
5,0 (454 comentarios)
7,5
7,5
Avatar del usuario
I am interested to do this project. ..............Can start now............................................Lets start
$15 USD en 30 días
4,9 (165 comentarios)
7,3
7,3
Avatar del usuario
Hello, I'll give you excel formula for this task. Just contact with me. Thank you and Best regards, Hoang
$15 USD en 1 día
5,0 (194 comentarios)
7,2
7,2
Avatar del usuario
Lets start. Having a team of Professionals. We provide high quality work with accuracy. Would you like to discuss more about your current requirements?
$15 USD en 1 día
4,9 (294 comentarios)
6,7
6,7
Avatar del usuario
Hey, I am an excel expert and can create macro that will allow you to round to nearest 9 for all items in your list on click of a button. Can you share a sample sheet with some dummy data? I would be able to write the code in it and send it back. Please drop a message to me if you would like me to work on this project for you and we may discuss the next steps. Look forward to working with you and thank you for considering my bid. Regards, Rishi Automyze Consulting - The Business Process Automation and Optimization Experts
$22 USD en 3 días
4,9 (148 comentarios)
6,7
6,7
Avatar del usuario
I am an Excel expert. I can round off the prices as you described with 100% accuracy and provide you the formulas for this. Please send the file. Thanks!
$15 USD en 1 día
5,0 (204 comentarios)
6,6
6,6
Avatar del usuario
I can give you the formula how to do it.. No VBA,.. Thank you and I'm looking forward to hearing from you
$16 USD en 1 día
5,0 (96 comentarios)
6,2
6,2
Avatar del usuario
Hello there my beloved employer, I have gone through your project description and clearly understood what you need me to do(Manual). Let me show you my reliability, dedication, honesty, accuracy, attention to details, etc. I may not be in the top of the bidders but i might be in the top for the quality of work that i do. Instead of giving this work to an agency who will split up the work among the worst to best freelancer you better award it to me to get only the best result with 0% errors or mistakes. You can just test me for a week so you get to understand that i am the best fit for this position. I don't want to talk more about me because when we do the trail then you will get to know everything about me in real than words. Most of the employers here hire me after the test to make sure that they hired the right person. So i humbly request you to reply me so that i can prove myself. None of my past clients leave a bad feedback on my profile because I work for their satisfaction not only for the money. This is the reason behind my success. I assure you that my work will have 100% accuracy and satisfactions of yours is always guaranteed. Let me show you how i am eligible to do this task. Let me know your thoughts. Looking forward for your reply. Thanks.
$15 USD en 15 días
4,6 (98 comentarios)
6,5
6,5
Avatar del usuario
Hello. I understand your requirements for this job and I am very interested to work on it. I have a formula that does this automatically. I am a reliable and hard working freelancer with 2 years of work experience on this site, very focused on the quality and accuracy of the work done. Kindly consider my proposal. Thank you.
$15 USD en 1 día
5,0 (131 comentarios)
6,2
6,2
Avatar del usuario
I have vast and excellent experience in Excel and Arithmetic. I have done several similar project before and my clients are always 100% satisfied. I'm a very meticulous freelancer who takes quality job as a priority and I'm also time cautious.. I'm also time cautious and give the best I have to every Project. Thanks. The Project would be completed in a few hours.
$15 USD en 3 días
5,0 (49 comentarios)
5,9
5,9
Avatar del usuario
Dear Employer, I am a dedicated freelancer from India, with 12 years experience in excel. I have executed similar projects with 5* ratings for all of them. I will round prices of all products to 9's (as shown by you). I will complete this in one hour and give you the output file. I am very much interested in this project and I would like to work in longterm if you wish. Kindly message me with further details. Thank you. Have a nice day.
$15 USD en 1 día
5,0 (65 comentarios)
5,0
5,0
Avatar del usuario
Hello. As I see, you want not ROUND, but ROUND UP to 9 all values? I can make this in one day. let's deal!
$15 USD en 1 día
5,0 (18 comentarios)
4,3
4,3
Avatar del usuario
Hi there I can do this excel job. and give you the formula for it Link of similar work is https://www.freelancer.in/jobs/project-8292568/ https://www.freelancer.in/jobs/project-8107843/ I am fast, accurate and reliable professional freelancer. See my reviews for the quality of work done. Ready to start right now. Pm me for further discussion Please consider my bid Thanks
$24 USD en 3 días
4,8 (35 comentarios)
4,7
4,7
Avatar del usuario
Dear client, I have a lot of experience with VBA and Excel. I can run a code over the excel file. Send me a message for more information. Looking forward to work with u. Kind regards, Rens Slenders SlenDATA
$20 USD en 3 días
4,8 (15 comentarios)
4,4
4,4
Avatar del usuario
Hi sir I can do it easily and I am awaiting to your response please message me also I have your file.
$16 USD en 2 días
5,0 (3 comentarios)
3,8
3,8
Avatar del usuario
Hi, I already have a formula for this. Please send a message so we can discuss. And also so I can send the file to you. Thanks, Chris
$22 USD en 3 días
5,0 (9 comentarios)
3,5
3,5
Avatar del usuario
Dear employer, I just want to let you know that I have the formula and it works for any number as you requested. The formula takes any number that doesn't end in 9 and round it up to next 9.
$16 USD en 1 día
4,8 (9 comentarios)
3,3
3,3
Avatar del usuario
It is very Simple project. i can do this with in a day and i will tell you the process. you just need to copy and paste the formula. All prices will be rounded up automatically. You may discuss with me regarding this project.
$16 USD en 3 días
5,0 (22 comentarios)
3,2
3,2

Sobre este cliente

Bandera de NORWAY
Lindesnes, Norway
5,0
21
Forma de pago verificada
Miembro desde mar 18, 2014

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos 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)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.