Find Jobs
Hire Freelancers

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

$15-25 USD / hour

Completed
Posted over 8 years ago

$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.
Project ID: 8572199

About the project

64 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

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:
User Avatar
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 in 1 day
5.0 (1 review)
0.7
0.7
64 freelancers are bidding on average $21 USD/hour for this job
User Avatar
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 in 3 days
4.9 (476 reviews)
8.2
8.2
User Avatar
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 in 3 days
5.0 (496 reviews)
7.9
7.9
User Avatar
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 in 62 days
5.0 (454 reviews)
7.5
7.5
User Avatar
I am interested to do this project. ..............Can start now............................................Lets start
$15 USD in 30 days
4.9 (165 reviews)
7.3
7.3
User Avatar
Hello, I'll give you excel formula for this task. Just contact with me. Thank you and Best regards, Hoang
$15 USD in 1 day
5.0 (194 reviews)
7.2
7.2
User Avatar
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 in 1 day
4.9 (294 reviews)
6.7
6.7
User Avatar
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 in 3 days
4.9 (148 reviews)
6.7
6.7
User Avatar
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 in 1 day
5.0 (204 reviews)
6.6
6.6
User Avatar
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 in 1 day
5.0 (96 reviews)
6.2
6.2
User Avatar
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 in 15 days
4.6 (98 reviews)
6.5
6.5
User Avatar
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 in 1 day
5.0 (131 reviews)
6.2
6.2
User Avatar
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 in 3 days
5.0 (49 reviews)
5.9
5.9
User Avatar
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 in 1 day
5.0 (65 reviews)
5.0
5.0
User Avatar
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 in 1 day
5.0 (18 reviews)
4.3
4.3
User Avatar
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 in 3 days
4.8 (35 reviews)
4.7
4.7
User Avatar
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 in 3 days
4.8 (15 reviews)
4.4
4.4
User Avatar
Hi sir I can do it easily and I am awaiting to your response please message me also I have your file.
$16 USD in 2 days
5.0 (3 reviews)
3.8
3.8
User Avatar
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 in 3 days
5.0 (9 reviews)
3.5
3.5
User Avatar
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 in 1 day
4.8 (9 reviews)
3.3
3.3
User Avatar
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 in 3 days
5.0 (22 reviews)
3.2
3.2

About the client

Flag of NORWAY
Lindesnes, Norway
5.0
21
Payment method verified
Member since Mar 18, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.