Excel formula help
$30-250 USD
Betalt ved levering
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.
Projekt ID: #19787264
Om projektet
29 freelancere byder i gennemsnit $63 timen for dette job
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.
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
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 automate Flere
Hello, I can help to write an Excel formula to calculate incremental values. Let’s discuss if you’re interested. Best regards, Duong
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 carefull Flere
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
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. Flere
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.
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
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
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
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 Flere
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 Flere
Want to take as a fun challenge for free of cost. Please ping me back i will try to help you out . Thanks
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!
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.
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 Flere