Find Jobs
Hire Freelancers

Excel formula help

$30-250 USD

Completed
Posted almost 5 years ago

$30-250 USD

Paid on delivery
I need to calculate a number in a cell based on IF formula. If salary is $20,000,000 over allowed baseline then penalty is $4.75. At each additional $5,000,000 penalty increases by factor of $.50. So in perfect world a formula to calculate these incremental values. $20,000,000 over allowed baseline salary times $4.75 penalty $25,000,000 times $5.25 penalty $30,000,000 times $5.75 penalty $35,000,000 times $6.25 penalty Include every $5,000,000 increment to $60,000,000 Lastly, if salary is $21,000,000 for example that penalty should be approx. $4.85? This indicates 20% of .50 as an increment. $22,000,000 would be 40% of .50 or approx. $4.95 x $22,000,000. And so on and on. Is this correct? How may I write this formula that will calculate number based on figure in another cell? I will have one cell for total salary, another cell for final penalty given rate above. Thanks! Not nimble enough with Excel A cell that automatically calculates value based on number in another cell.
Project ID: 19787264

About the project

29 proposals
Remote project
Active 5 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
Hi, this is actually very simple, i can create this formula for you in matter of minutes. If you are interested in working with me, please message me and i will help immediately. I already know what i need to do exactly. Thanks, Milan
$30 USD in 0 day
5.0 (661 reviews)
7.3
7.3
29 freelancers are bidding on average $63 USD for this job
User Avatar
Hello, I’m an Excel expert and I would like to help you with your formula. Please check my profile and contact me to discuss further details. Regards.
$50 USD in 1 day
5.0 (490 reviews)
8.0
8.0
User Avatar
Hello Sir Im excel VBA macro and formula Expert :) i can make calculator like u said in project description please ping me now and im free now Thank you Galih
$30 USD in 1 day
4.9 (427 reviews)
7.6
7.6
User Avatar
I can definitely help you with that. I am a professional Excel expert holding years of experience in utilizing advance level tools and functions of Excel including VBA and Macro to develop financial models and automated tax calculators. I will be happy to discuss in detail how I am highly suitable for this project.
$45 USD in 1 day
4.8 (155 reviews)
7.0
7.0
User Avatar
Hello, I can help to write an Excel formula to calculate incremental values. Let’s discuss if you’re interested. Best regards, Duong
$30 USD in 0 day
4.9 (66 reviews)
6.7
6.7
User Avatar
Hello. I 'm expert in "Data Entry, Data Processing, Excel, Mathematics, Statistics" and I have working for 7+ years in this field. I 'm very interest to your project. I have checked your project description carefully and i can do it. I 'll do my best till you satisfy if you want me. Contact me please. Thank you. Yang L.
$140 USD in 1 day
4.8 (91 reviews)
5.9
5.9
User Avatar
Hello, I can provide you a, simple excel formulae for this which can take care of this calculation. Shall be happy to assist. Kind regards, Anjul
$55 USD in 1 day
5.0 (40 reviews)
5.8
5.8
User Avatar
I am experience SPSS, Minitab. Stata, Excel. Presentation, Power pivot table, regression (Trend line) & correlation analysis, statistical test, linear programming, formula creation, graph creation and report writing. You may go through Finance Trading Statistical Analysis, Academic Research Paper and Water Bottle Market Survey file (https://www.freelancer.com/u/EngrShahidul.html), for my relevant skill please. Let me know your data and objective of study (requirement of analysis), so that I can think of job.
$100 USD in 3 days
4.8 (109 reviews)
5.6
5.6
User Avatar
HELLO! As an: - Bachelor of Applied Mathematics - Engineer in Statistics and Applied Economics - Microsoft Office Technician (Microsoft Graduate: MOS Diploma), - I have skills in programming language R, Python, Minitab, SPSS, STATA I am able, available and ready to do this kind of work in the best conditions, ------------------------------------------------------------
$80 USD in 3 days
5.0 (27 reviews)
4.6
4.6
User Avatar
Hi! Your proyect can be done in a morning, im glad to do it. Regards, Emiliano Im an MsExcel expert programer, formuals Dashboards, Reports, etc.
$30 USD in 1 day
5.0 (18 reviews)
4.6
4.6
User Avatar
Hi, I have worked with conditional excel data manipulation. I would like to work on this project. Let me know if you want to discuss further Regards, Monir
$100 USD in 2 days
4.9 (7 reviews)
4.3
4.3
User Avatar
Hello, Sir Weebside Inc. is a professional freelancer service provided to worthy clients like you. We can provide our best developers to provide you High-Quality Product with 100% Delivery Rate, 100% Satisfaction. Having Experts in Java, C / C++ , C# , VB , .NET , SQL, MySQL, and Python Programming Language and Frameworks made us capable to bid here. We can provide any service of any caliber within Hours. CHAT WITH US TO START RIGHT NOW. BEST DEVELOPERS AROUND. WITH HIGHEST QUALITY DELIVERED WITHIN TIME. WITHIN BUDGET. CLICK CHAT TO START
$34 USD in 1 day
4.7 (5 reviews)
2.8
2.8
User Avatar
Hello, I read your desription and you can make formula in Excel if fixed first value 4.75. Send me a message and we can discuss more
$55 USD in 1 day
4.9 (5 reviews)
2.7
2.7
User Avatar
Dear, This is simply task. I can deliver the formula in a days. In addition, I also can offer only 20 usd. However, I wrote 30 usd in my bid because minimum range is 30 usd. Best Regards
$30 USD in 1 day
5.0 (2 reviews)
1.9
1.9
User Avatar
Hello.. I'm an Electrical Engineer with ample amount of experience in Microsoft Office and Programming. I had done a lot of work in Word, Excel and Powerpoint and can do this for you with ease and perfection. I can do this in no time for you. We can discuss further details over chat. Looking for your positive response. Regards, Abdul Hannan
$35 USD in 1 day
5.0 (5 reviews)
1.6
1.6
User Avatar
Hi This formula is very similar to the UK's Medical insurance premiums calculations which we use in a number of our excel sheets with upper and lower limits and rates apportioned across the range for given salaries I our case we use a helper sheet to allow these limits to be changed (They alter every year in the UK) so that we don't have to manually edit the formulas when the rates/limits change as hard coding can make the formula difficult to edit, but can be done this way if required Please message if you would like me to code the formula and/or Helper sheet for you Regards Alan Sheppard
$35 USD in 1 day
5.0 (1 review)
1.2
1.2
User Avatar
Want to take as a fun challenge for free of cost. Please ping me back i will try to help you out . Thanks
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I have over 6000 hours of experience building complex Excel files, formulas, and macros. Let me assist you as soon as possible with this project. Thanks!
$133 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I am interested in working in your project. I have good experience in Excel & can help you here. We can discuss more about need over chat.
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, my name is Ivan and I am an IT Tehnician from Croatia. I think this might be the perfect job for my position because I have been in business for over 4 years now. We can discuss further details in the chat. I hope we get along well. Greetings.
$30 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Estimados Señores, presento mi oferta de servicios profesionales para su proyecto “Agregar comentarios para productos con el software excel”, en un tiempo razonable para garantizar la calidad del trabajo entregable. Me gustaría conocer más detalles sobre su proyecto. Mi idioma es el español y entiendo bastante bien el inglés escrito. Soy Licenciado en Contaduría Pública, con Maestría en Dirección y Administración de Empresas, Postgrado en Formulación y Evaluación de Proyectos de Inversión y Título de profesor en Ciencias Comerciales. Con más de 20 años de experiencia en Formulación y Evaluación de Proyectos de Inversión, Contabilidad, Finanzas, Análisis de Estados Financieros, Presupuestos, Aplicación de la Metodología ABC en el Costeo de Productos y Servicio; elaboración de proyecciones financieras de corto y mediano plazo; participación en la elaboración de Bases de Licitación e integrante de Comisiones Evaluadoras de Ofertas en procesos de Licitación Pública y acostumbrado a trabajar con información confidencial de prestigiosas empresas. Responsable de la revisión y presentación de informes técnicos y documentos de investigación, para la toma de decisiones financieras, aplicables a diferentes tipos de negocios y proyectos de inversión; con procesamiento previo de información en Excel, Word y Power Point, con precisión y atención a los detalles. Atentamente.
$100 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Burlingame, United States
5.0
1
Payment method verified
Member since May 26, 2019

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)
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.