I need a simple excel formula to calculate rebate for a customer based on a table of rebate calculations.
Rebate table is as follows:
0 10000 0.05%
10001 25000 0.065%
25001 50000 0.08%
50001 100000 0.10%
100001 200000 0.125%
200001 … 0.15%
It works as follows: if someone spends 10,000, they will get 10,000*0.05% rebate
If someone spends $15,000, they will get 10,000*0.05% + 5,000*0.065%
If someone spends $30,000 they will get 10,000*0.05% + 15,000*0.065% + 15,000*0.08%
and so on
Hi Sir,
This is a very simple project. Please give me the chance to complete this job. I am able to handover this job within same day.
Relevant Skills and Experience
I have 10 years experience of doing this type of formula in excel. I am a software developer so this logic is very simple.
Proposed Milestones
$15 AUD - Well experience in MS_Excel and I am a software developer so this logic is very simple.
Hi,
I am good at Excel and formulas. I can use vlookup to get the required. I can provide the solution in less than 20 minutes.
-Chandra
Relevant Skills and Experience
Excel vba, formulas
Proposed Milestones
$14 AUD - Milestone
I have 7 years of experience with 100% client satisfaction history. I ll develop a button in excel. On click, button will calculate your all rebate. See my profile for client reviews.
Relevant Skills and Experience
Excel VBA MBA
Proposed Milestones
$30 AUD - only
Looking for your response.
I can calculate the rebate using formulas in excel. Contact me to discuss further on the project.
Relevant Skills and Experience
Excel
Proposed Milestones
$30 AUD - Milestone
Hi there, I have expertise on Number Typing. My typing speed is 60 WPM with 99% accuracy. Previously I have completed these kind of projects successfully as a freelancer. You can hire me confidently.
Relevant Skills and Experience
Excel
Proposed Milestones
$25 AUD - Project Milestone
Hello
I got it .. I'm excel Expert I can start work immediately ...... I will deliver it within few hours (5-6)
if you have any question please message me
Relevant Skills and Experience
Excel
Proposed Milestones
$13 AUD - create Milestone
if you have any question please message me
I worked for Haier Europ trading.... We were wholesaler and I used to calculate all the rebates and are more complicated % as it depends on total sales and payment date (15 days)
I believe once I have a look at the data, I will be able to determine completion date and time.
Regards
Salah
Make a fomula for you excel
Habilidades y experiencia relevante
I am an engineer I work with excel and formulas every time, let me try
Htos propuestos
$25 AUD - formula excel
Hi.. I saw your ad for an excel expert.. I want to work with you on this if you will accept my proposal. Thanks
Relevant Skills and Experience
Excel
Proposed Milestones
$20 AUD - Proposed Milestone
i am not an expensive person i want to earn some money and i have been working in excel since i have 10 years old.
Relevant Skills and Experience
i am patient, i am a good mathematician. i love numbers and so on.
Proposed Milestones
$25 AUD - i can calculate every thing you want, including numbers with 10 digits and so on
Additional Services Offered
$1 AUD - i have a few c++ skills
I'm working as a "planning and control Coordinator" in a multinational oil and gas company, responsible for developing the planning department models and improving the current ones.
Models:
Profit and loss
Balance sheet and cash flow
G&A automatic allocation model
Production database
NPV & IRR economic evaluation model
JOA overhead scheme (similar to the rebate request)
Worked as a general accounting section head for 3 years.
Sap / oracle/ Hyperion/ swap experience
Excel / excel vba experience
Thanks