Need to create the formulas for 2 calculations in this Google Sheet
Please only bid if you know exactly how to do that easily. Should take 10 minutes or less for somebody who knows how to write that fomula.
Here is the google doc to fill out
https://docs.google.com/spreadsheets/d/131haglpmyzyZMB1lnzXpvczqtmoP9l2_FEsabysoEkQ/edit#gid=0
the rule is the following for the cell B2
if B1<1000, it's scenario A and B2=30%
if B1 is between 1,000 to 4,999, it's scenario B and B2=33%
if B1 is between 5,000 and 9,999, it's scenario C and B2=35%
if B2 is 10,000 and more, it's scenario D then B2=40%
For the cell C5 the calculation is the following
if B3=NO, then B2,
if B3=YES, then B3 varies dependending on the scenario
If scenario A then B3=15%
If scenario B then B3=23%
If scenario C then B3=29%
If scenario D then B3=34%
Please copy the data in a new Google sheet to prepare the formula
Thank you
Expert Excel Programmer on freelancer.com and have been featured by the freelancer community https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story)
Relevant Skills and Experience
I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you.
Proposed Milestones
$34 USD - Please pay me once the job is 100% complete
Hello
I have reviewed the sheet and will deliver the work as required.
Please consider my bid
Rohit
Pithisaria Consultancy services
Relevant Skills and Experience
Excel
Google spreadsheet
Proposed Milestones
$25 USD - Milestone
Turnaround time - 1 hr
i have good command over ms excel especially pivot table, charts, advance formulas etc. Do let me know
Relevant Skills and Experience
Ms excel, spreadsheet
Proposed Milestones
$23 USD - upon completion
Dear Employer,
Fast and accurate work with good communication guaranteed.
I am a reliable freelancer. Plus bid amount can be negotiated.
Looking forward to get hired soon to start the work.
Relevant Skills and Experience
I have a lot of experience on excel and google sheets. U will be more than pleased with my work.
Proposed Milestones
$12 USD - Project completion
Write 2 conditional formulas on a goole sheet
Relevant Skills and Experience
I'm used to excel. I'm using it daily in my internship, and did a lot of workon it using cconditions;
Stay tuned, I'm still working on this proposal.
Hi There,
I will do it in 5 min. It is very easy task for me. Trust me I will not disappoint you. Let me give 1 chance. If you love my work then please rate me with full stars.
Relevant Skills and Experience
I am new here but doing this type of work seance 2 years. (excel vba, formula, copy writing , etc)
Proposed Milestones
$10 USD - Final payment
My bid for your request is fair. I already made the first calculation, so I can help you very fast if you choose me. I am available in the next hours, so you will get this done very quickly
Relevant Skills and Experience
I have been working as a business analyst in the last 4 years. Almost all of my work is in Excel, so I'm good at it.
Proposed Milestones
$10 USD - Formulas done