Suoritettu

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.

Taidot: tiedonsyöttö, tietojenkäsittely, Excel, Matematiikka, Tilastotiede

Näytä lisää: 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

Tietoa työnantajasta:
( 0 arvostelua ) Burlingame, United States

Projektin tunnus: #19787264

Myönnetty käyttäjälle:

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 Lisää

$30 USD 0 päivässä
(463 Arvostelua)
6.9

33 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 päivässä
(358 arvostelua)
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 päivässä
(293 arvostelua)
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 päivässä
(34 arvostelua)
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 Lisää

$30 USD 0 päivässä
(113 arvostelua)
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] Lisää

$40 USD 1 päivässä
(96 arvostelua)
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 Lisää

$140 USD 1 päivässä
(75 arvostelua)
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. Lisää

$100 USD 3 päivässä
(52 arvostelua)
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 Lisää

$45 USD 1 päivässä
(53 arvostelua)
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 päivässä
(6 arvostelua)
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 päivässä
(6 arvostelua)
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 Lisää

$34 USD 1 päivässä
(5 arvostelua)
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 päivässä
(1 arvostelu)
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 Lisää

$80 USD 3 päivässä
(7 arvostelua)
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 päivässä
(1 arvostelu)
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 Lisää

$35 USD 1 päivässä
(4 arvostelua)
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 Lisää

$35 USD 1 päivässä
(1 arvostelu)
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 Lisää

$30 USD 1 päivässä
(1 arvostelu)
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 päivässä
(0 arvostelua)
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 päivässä
(0 arvostelua)
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 päivässä
(0 arvostelua)
0.0