Find Jobs
Hire Freelancers

Spreadsheet IF/ELSEIF/ELSE Conditional Calculation statement

$10-30 USD

Tamamlandı
İlan edilme: 8 yıldan fazla önce

$10-30 USD

Teslimde ödenir
I need an IF/ELSE conditional statement to be able to correctly calculate Points and Profit/Loss for numbers that have different decimal values on each row, ie: Row 1: 1.23456 - 100 points ( 5 decimals) Row 2: 123.456 + 80 points (3 decimals) Row 3: 12,345.67 + (2 decimals) I have attached a spreadsheet which contains the data exactly as it needs to be displayed and calculated. At the moment I calculate each row's Points and Profit/Loss individually depending on how many decimals there are, but what I want is to use one "IF" statement that will calculate correctly no matter how any decimals there are, that I can copy/paste/fill for every row. I would like to pick a programmer and start immediately please!
Proje No: 8242513

Proje hakkında

22 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
Seçilen:
Kullanıcı Avatarı
Hi, I am good at excel. Please have a look at my testimonials. I would like to have discussion once. Looking forward to work on this project.
$15 USD 0 gün içinde
5,0 (40 değerlendirme)
4,6
4,6
22 freelancers are bidding on average $24 USD for this job
Kullanıcı Avatarı
Dear Sir/Madam, Just send me the file trough message box. I will first put the formulas, if you are done, you can offer me the job. Waiting fro your reply to start. Best regards, Priyal
$30 USD 1 gün içinde
5,0 (139 değerlendirme)
6,4
6,4
Kullanıcı Avatarı
I am an ACCA (UK) professional , APA and Mcom finance. After carefully reading your project description, I think that I am the perfect candidate! With over 8 years of experience in advanced use of MS Excel, I can guarantee getting the job right the first time. Feel free to view my 100% positive reviews before you hire me and rest assured that you will receive top-quality work at an affordable cost. Kind regards, Javed
$34 USD 1 gün içinde
4,9 (54 değerlendirme)
5,6
5,6
Kullanıcı Avatarı
Hola (my native language is spanish), my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
$30 USD 3 gün içinde
4,9 (61 değerlendirme)
5,7
5,7
Kullanıcı Avatarı
Hello Sir Im excel VBA mcro and formula Expert :) please give me your job and im able to start doing your job right now :) Thank You Sincerely Prameswara :)
$15 USD 0 gün içinde
4,9 (88 değerlendirme)
5,3
5,3
Kullanıcı Avatarı
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. Expert in MS office, which includes formatting, powerpoint presentation, mail merge, 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.
$29 USD 1 gün içinde
4,9 (28 değerlendirme)
4,8
4,8
Kullanıcı Avatarı
please clarify deadline .
$30 USD 3 gün içinde
5,0 (11 değerlendirme)
4,5
4,5
Kullanıcı Avatarı
Feel free to contact me for Conditional Calculation statement . Budget is not any issue as well.I have team for quick and quality results. We can manage each and everything via private messages. Take a look on my 5 start feedback work.
$25 USD 1 gün içinde
4,7 (14 değerlendirme)
4,0
4,0
Kullanıcı Avatarı
I am an accurate and reliable business/Accounting/finance Analyst. I am a proficient business expert with over eight years writing experience. I have experience in Business plan writing, payroll, bank reconciliation, journal entries, cash flow, income statements, budgets, work plans, and financial reporting.
$40 USD 1 gün içinde
5,0 (3 değerlendirme)
2,6
2,6
Kullanıcı Avatarı
Dear Sir/Madam, thank you for clear project description. I'm a professional freelancer worker. I've an efficient knowledge on web searching job for specific informations. I know about CMS or web forms data entry well. according to your project requirements, willing to complete 5 steps under your project. high quality and stipulated time frame service. searching a long term opportunity. I do 16 hours work on online . so instant support. let's discuss further details for start thanks and regards by shifa1988
$15 USD 1 gün içinde
5,0 (5 değerlendirme)
2,4
2,4
Kullanıcı Avatarı
I am expert in excel, Please contact and give me either your excel file or teamviewer access. Thanks.
$30 USD 1 gün içinde
5,0 (1 değerlendirme)
1,3
1,3
Kullanıcı Avatarı
Hi, I have read your posting job carefully. I am looking for a job like this. I can do your job perfectly and also assure you that my work will be 100% satisfied to you. Best regards Shariful
$25 USD 1 gün içinde
5,0 (6 değerlendirme)
1,4
1,4
Kullanıcı Avatarı
Dear Sir, MUST MESSAGE to me YOUR WORK IS COMPLETED There is no difficult I can tell about all for next you can do it easily. I m excel expert with lot of experience and seeking job as freelancer. I wants to work where I can show my excellent work. So, give me work and before awarding take your complete work and then pay to me.. You can also ask me before award to me. thanks
$15 USD 1 gün içinde
5,0 (1 değerlendirme)
0,7
0,7
Kullanıcı Avatarı
Highly organized, self-motivated with a positive attitude, willing to work within a team, thorough, committed to professionalism and very timely. I have expert knowledge in excel- calculation, charts, report and most of it said functionalities- and can easily navigate through the software. I get the job done! No excuses or delay- just get the job done the right way in the only acceptable manner- high quality. I am willing to take the time to go through each task to ensure you're getting the highest quality for what you want. I look forward hearing from you soon.
$25 USD 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
Hello. I'm understand how to do this job. Skills in VBA, experiance of working in excel, access two years. No problem with this job and those tasks from discription. I have birthday today, so you can so you can give me a present and accept my bid. Good luck and succeed in this project. Note: In string "POINTS must be displayed as whole numbers with 2 decimal points. POINTS are calculated as follows: IF Col C = “S” (ENTRY – EXIT) * STAKE, elseIF Col C = “B”: (ENTRY – EXIT) * STAKE" you wrote repeating formula for both cases, so may be it's error.
$10 USD 3 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
Generar lo que el empleador requiere en Excel, primero conversar para estar 100 % seguro de lo que el empleador desea que se realice.
$15 USD 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
Sir, I am a dynamic problem solver and can assured you to do best for you exactly as you expecting with great quality and faster complete rate. Tools : Excel , Advance Excel, SQL Query, Multiple If Else, IFF ,VBA etc. Deepak Garg
$25 USD 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
Hi, I do not understand very well, because the value of column POINTS you say in document that is calculated according to column "C" as (ENTRY – EXIT) * STAKE in both cases, so you need to clarify that. On other hand, I like this kind of job and I consider myself very good skills on programming spreadsheets, this one is OpenOffice spreadsheet. So I propose doing this formula within some hours for a low cost. Samael
$15 USD 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
A proposal has not yet been provided
$25 USD 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
Hi, I am good at excel. Can you forward me your excel to solve the issue. Looking forward to discuss with you on the terms and timelines for the project, Regards, JSK
$24 USD 1 gün içinde
5,0 (1 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
A proposal has not yet been provided
$25 USD 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0

Müşteri hakkında

   SPAIN bayrağı
Croydon, Spain
5,0
38
Eki 28, 2010 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.