Excel formula help

Færdiggjort Opslået 4 år siden Betalt ved levering
Færdiggjort 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.

Dataindførsel Databehandling Excel Matematik Statistikker

Projekt ID: #19787264

Om projektet

29 bud Remote projekt Aktiv 4 år siden

Tildelt til:

MimiFL

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 exactl Flere

$30 USD in 0 dage
(661 bedømmelser)
7.3

29 freelancere byder i gennemsnit $63 timen for dette job

P0L

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 på 1 dag
(490 bedømmelser)
8.0
prameswara

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 på 1 dag
(427 bedømmelser)
7.6
daniyal3214

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

$45 USD på 1 dag
(155 bedømmelser)
7.0
hdlan

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 dage
(66 bedømmelser)
6.7
lightingdavid

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

$140 USD på 1 dag
(91 bedømmelser)
5.9
Anjulagrawal26

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 på 1 dag
(40 bedømmelser)
5.8
EngrShahidul

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

$100 USD in 3 dage
(109 bedømmelser)
5.6
Galata16

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, Minita Flere

$80 USD in 3 dage
(27 bedømmelser)
4.6
emilianoreyes70

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 på 1 dag
(18 bedømmelser)
4.6
Arahan00

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 dage
(7 bedømmelser)
4.3
IFI91

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. Ha Flere

$34 USD på 1 dag
(5 bedømmelser)
2.8
maliamaza

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 på 1 dag
(5 bedømmelser)
2.7
khabibki06

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 på 1 dag
(2 bedømmelser)
1.9
TheAnsari97

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

$35 USD på 1 dag
(5 bedømmelser)
1.6
frlncrsZviDAyqG

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

$35 USD på 1 dag
(1 bedømmelse)
1.2
spa5847c40226df0

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 dage
(0 bedømmelser)
0.0
andresalizaga

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 dage
(0 bedømmelser)
0.0
ankushagarwal87

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 på 1 dag
(0 bedømmelser)
0.0
munlajo

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 ho Flere

$30 USD in 2 dage
(0 bedømmelser)
0.0
PedroGuzman2018

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

$100 USD in 10 dage
(0 bedømmelser)
0.0