Find Jobs
Hire Freelancers

Adjust an existing excel formula

£10-20 GBP

Sürüyor
İlan edilme: 8 yıldan fazla önce

£10-20 GBP

Teslimde ödenir
I currently have a formula that nicely tidies up some prices for me. It rounds to the nearest .05 or .09, so for example 3.43 becomes 3.45 and 8.96 becomes 8.99. The only issue is that I want it to round down, only in the case that the figure just above a round number. So if it's 8.01, I'd like it to round down to 7.99 instead of round up to 8.05. I've attached a spreadsheet that shows my formula, and highlighted the cases that I want it to round down instead. Can this be done?
Proje No: 8435801

Proje hakkında

25 teklif
Uzaktan proje
Son aktiviteden bu yana geçen zaman 9 yıl önce

Biraz para mı kazanmak istiyorsunuz?

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir
25 freelancer bu proje için ortalama £15 GBP teklif veriyor
Kullanıcı Avatarı
Hi, I am good at excel. Looking forward to work on this project. I have understood the requirement.
£18 GBP 0 gün içinde
5,0 (1240 değerlendirme)
8,5
8,5
Kullanıcı Avatarı
Dear client, I can accomplish the job for you. I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me for further details. Thanks and regards Roy
£10 GBP 0 gün içinde
5,0 (511 değerlendirme)
7,8
7,8
Kullanıcı Avatarı
A proposal has not yet been provided
£30 GBP 0 gün içinde
4,9 (257 değerlendirme)
7,7
7,7
Kullanıcı Avatarı
Yes it can be done ;) You dont need to recruit me to finish this. Drop me a message, give me a bit time and i can complete it. If you get happy happy we can progress. (as i need some good references in my profile, i provide this service) I have a 5,5 years of business analyst experience in a global company and 2,5 years data scientist experience in a game company before my freelancer career. Excel is my legs and arms. I can make any reporting, formulas, pivot tables, macros etc. I am mostly online. Just drop me a message so that we can discuss further about pricing and job details. Thanks,
£18 GBP 1 gün içinde
5,0 (149 değerlendirme)
7,3
7,3
Kullanıcı Avatarı
********************************* I have completed****************************************** I think I am a good fit for this job because I have all the qualities that you are looking for. Experience is the golden factor in this project where you find in me at least 3+ years of working experiences over all the factors in your project.
£10 GBP 1 gün içinde
5,0 (96 değerlendirme)
6,9
6,9
Kullanıcı Avatarı
Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 250 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
£20 GBP 1 gün içinde
4,9 (181 değerlendirme)
6,5
6,5
Kullanıcı Avatarı
Hello Dear, I can do this for you. Please send a massage in the PMB for details.......Best Regards flashsaiful
£17 GBP 1 gün içinde
4,9 (170 değerlendirme)
6,8
6,8
Kullanıcı Avatarı
Hello I am an excel expert and would like to bid on the project posted by you. I have completed more than 100 projects in excel. FYI: Freelancers are not authorized to send any attachments to the employer before we receive any personal message from the client. I request you to kindly initiate the conversion so that I can send examples of my work. Rgds Rohit Pithisaria
£13 GBP 1 gün içinde
4,9 (122 değerlendirme)
6,7
6,7
Kullanıcı Avatarı
Dear Sir, Done numerous similar projects in past the and always impressed the clients with my excellent VBA solutions. Out of my 40 projects, almost 35+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in MS excel, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
£14 GBP 0 gün içinde
4,9 (87 değerlendirme)
6,2
6,2
Kullanıcı Avatarı
Hello, I can get this task done in the next 30 mins to 1 hour. Let me know if you are interested. Thanks
£12 GBP 0 gün içinde
5,0 (117 değerlendirme)
6,1
6,1
Kullanıcı Avatarı
Dear employer I am an ACCA member with 5 years experiences as auditor in Grant Thornton (Top 5 audit firm). You could check my profile https://www.freelancer.com/u/cuongtn.html My working experience: + Senior auditor, Financial Analyst, Internal Auditor + Prepared financial statement under IFRS, IAS + Analyst: familiar with prepare financial analysis, investment analysis. + Internal auditor: Compliance audit, Review internal control system, Design the internal control system, make recommend on internal control system. Freelancer experience: a + Read FSs and annual report to create consolidate sheet with 12 annual report. + Prepare internal control report... + Quickbook, MYOB, Xero … Let's have a quick conversation. Hope to receive good news from you... Tran Nhu Cuong, ACCA, CPA Approach to the Job: - Discuss the detail of project - Send draft to employer - Make revision - Final report.
£10 GBP 1 gün içinde
4,9 (62 değerlendirme)
5,2
5,2
Kullanıcı Avatarı
Hi I'm Rody, from Egypt. I 'm a Translator from Arabic to English and vice versa (medical- science - articles - books - general - websites), Writing Articles and DATA ENTRY i can help you to complete your work Regards
£10 GBP 1 gün içinde
4,9 (35 değerlendirme)
4,6
4,6
Kullanıcı Avatarı
I am very interested in working online for you. I am interested in long term work. I have had 5+ years exp. in Computers, MS word, MS excel, Quickbooks, Office Management , PDF, Google spreadsheet Powerpoint, Vba and typing. I am looking to further my experience. I am very excited to work online. I will give you my best possible work. I would like to thank you in advance.
£13 GBP 1 gün içinde
4,9 (31 değerlendirme)
4,5
4,5
Kullanıcı Avatarı
HI there I can edit the excel formula as per your need. I am fast accurate and reliable freelancer. See my reviews for quality of work done. Ready to start right now. PM me for further discussion. Please consider my bid thanks
£19 GBP 1 gün içinde
4,8 (36 değerlendirme)
4,7
4,7
Kullanıcı Avatarı
Greetings! Since I saw this Project, I have been working on it. And I am glad to share that the formula is very much ready. Please give me an opportunity and I assure you that you will not regret. I take this opportunity to introduce myself as a highly talented Accountant and Analyst with strong technical knowledge and with an experience in the areas of Accounting, Algorithm, Audit and Business Analysis. With the Degrees in Engineering and MBA, I am specialized in Logical approaches and simplifying day to day business processes. With specialization in Excel and other Microsoft Office tools, I can provide the best reports merging different data from different reports exported from the software. If you need Customer/Vendor/Stock Analysis incorporating all data from different reports, then just hire me. Either it be sending many customized mails or printing many customized letters using Mail merge, or Business Reporting and Analysis or Presentations or Documentation of Reports or preparing some daily used templates like Invoice , I am one of the finest choices you can have. If your software cannot give you the right FIFO / LIFO adjustments for stocks and bills adjustment and you need ageing reports or bill wise adjustment for issuing Discounts, then I am the best choice. Give me an opportunity and trust me you will not regret it. Looking forward for a great association. Thanks & Regards Mohammed Ismail
£18 GBP 1 gün içinde
5,0 (1 değerlendirme)
3,2
3,2
Kullanıcı Avatarı
Hi, yes sure i can do it soon, you can have the excel fixed in a moment I wait your request (chat) to start soon Thanks
£18 GBP 0 gün içinde
5,0 (3 değerlendirme)
2,6
2,6
Kullanıcı Avatarı
Hi Sir, Complete your work with 100% accuracy and complete as soon as possible. Hope you give me Chance Thank You Sir
£10 GBP 0 gün içinde
4,7 (2 değerlendirme)
1,8
1,8
Kullanıcı Avatarı
I have around 10 years of experience in Microsoft Technologies. I am aware of all the tools, techniques and formula's related to MS excel. The output produced would be of high quality standards.
£10 GBP 1 gün içinde
5,0 (1 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
A proposal has not yet been provided
£16 GBP 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
Hi, This is a easy task for me. Just wait your details on how you can deliver material. Regards, Adrian
£12 GBP 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0

Müşteri hakkında

   UNITED KINGDOM bayrağı
Small Dole, United Kingdom
5,0
3
Ödeme yöntemi onaylandı
Tem 29, 2014 tarihinden bu yana üye

Müşteri Doğrulaması

Teşekkürler! Ücretsiz kredinizi talep etmeniz için size bir bağlantı gönderdik.
E-postanız gönderilirken bir şeyler yanlış gitti. Lütfen tekrar deneyin.
Kayıtlı Kullanıcı İlan Edlien Toplam İş
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ön izleme yükleniyor
Coğrafik konum için izin verildi.
Giriş oturumunuzun süresi doldu ve çıkış yaptınız. Lütfen tekrar giriş yapın.