# Excel formula help

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.

Квалификация: Ввод данных, Обработка данных, Excel, Математика, Статистика

О работодателе:
( 0 отзыв(-а, -ов) ) Burlingame, United States

ID проекта: #19787264

## Поручен:

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 Больше

\$30 USD за 0 дней(-я)
(463 отзывов(-а))
6.9

## 33 фрилансеров(-а) в среднем готовы выполнить эту работу за \$63

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 за 1 день
(358 отзывов(-а))
7.1
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 за 1 день
(293 отзывов(-а))
7.2
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 за 0 дней(-я)
(34 отзывов(-а))
6.3
mtdevil369

hi ,i am stat student . i will start your work now and complete within 5 hours .I'm an Excel expert with 8 years of experience, I can help you with your VBA/marco project please send me a message so we can discuss the Больше

\$30 USD за 0 дней(-я)
(113 отзывов(-а))
5.7
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Больше

\$40 USD за 1 день
(96 отзывов(-а))
5.6
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 Больше

\$140 USD за 1 день
(75 отзывов(-а))
5.7
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. Больше

\$100 USD за 3 дней(-я)
(52 отзывов(-а))
5.1
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 Больше

\$45 USD за 1 день
(53 отзывов(-а))
5.5
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 за 1 день
(6 отзывов(-а))
3.2
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 за 1 день
(6 отзывов(-а))
2.8
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 Больше

\$34 USD за 1 день
(5 отзывов(-а))
2.7
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 за 1 день
(1 отзыв)
2.4
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 Больше

\$80 USD за 3 дней(-я)
(7 отзывов(-а))
2.5
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 за 2 дней(-я)
(1 отзыв)
1.4
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 Больше

\$35 USD за 1 день
(4 отзывов(-а))
1.4
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 Больше

\$35 USD за 1 день
(1 отзыв)
1.1
alexsun1222

Hello, sir! I am happy to put my bid on your project. I have a full of experience in data processing using Excel formula and VBA. I have finished many projects like this. I promise I will do your project with high qual Больше

\$30 USD за 1 день
(1 отзыв)
1.0
Arbabsaqib

I will provide you a good service for [login to view URL] sheet must be relevant and very easy for use. I can mange the formulas which helps you for doing such work.

\$80 USD за 1 день
(0 отзывов(-а))
0.0
yunqiz

Hi, I know how to do this. I am a professional data analyst and graduated with master degree in Mathematics and Statistics from top US universities.

\$88 USD за 1 день
(0 отзывов(-а))
0.0
mehreenmanzoor80

Hi i am a fresh candidate i amexpert in excel i can make my own formulas Give me a chance to prove myself Contact me for more information Relevant Skills and Experience Excel

\$155 USD за 1 день
(0 отзывов(-а))
0.0