Завершено

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, Математика, Статистика

Показать больше excel formula help need onetomany vlookup type of formula, excel formula help, excel formula help: need one-to-many vlookup type of formula, excel formulas vlookup, basic excel formulas pdf, excel formulas percentage, ms excel formulas list, advanced excel formulas, excel formulas multiply, excel formulas pdf, excel formulas tutorial, need help with excel formula, which of the following error values means that excel doesn t recognize your formula because there is either a misspelled functio, excel formula to copy cell value from another sheet, excel formula to copy cell value to another cell, excel formula to compare two columns and return a value, excel formula color cell if value, excel formula if cell contains text then return value in another cell, excel increment cell value by 1 formula, excel formula if date is greater than 30 days from today

О работодателе:
( 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