Create 2 nested formulas in Google Sheet

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

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

Here is the transcription in excel of the Google Sheet

Here is the link that allow the small sheet to be viewed

Taidot: Excel, Matematiikka

Näytä lisää: google maps javascript create routes, type software need create brand clothing, information need create professional band myspace, multiple if formulas google sheets, google sheets multiple if statements in one cell, google sheets multiple if conditions, if between google sheets, lookup function google sheets, nested outcome google sheets, nested formulas google sheets, if and statement google sheets, excel, need create sports betting website, need create flash image banner website, need create web community, need create content publish, need create auction site, kind skills need create top quality commerce site, need create adult dating website, need create website cities

Tietoa työnantajasta:
( 40 arvostelua ) New York, United States

Projektin tunnus: #15538304

Myönnetty käyttäjälle:


I've written this exact nested formula hundreds of times. I will deliver well within 1 day. Relevant Skills and Experience 8 years as an Excel trainer. Proposed Milestones $10 USD - Write IF statement

$10 USD 1 päivässä
(1 arvostelu)

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


Expert Excel Programmer on and have been featured by the freelancer community Relevant Skills and Experience I am an En Lisää

$34 USD 0 päivässä
(583 arvostelua)

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

$25 USD 1 päivässä
(115 arvostelua)

hi, i understand your requirements, can you give me access to sheet? Stay tuned, I'm still working on this proposal.

$25 USD 1 päivässä
(127 arvostelua)

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

$23 USD 1 päivässä
(13 arvostelua)

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

$12 USD 1 päivässä
(5 arvostelua)

Hello there: I am a graduate in electrical engineering and passionate about the work of your [login to view URL] inbox so that i satisfy u about my capability. Waiting for your reply. Regards Stay tuned, I'm still worki Lisää

$25 USD 1 päivässä
(1 arvostelu)

Google sheet Expert Relevant Skills and Experience Google Sheet Expert Proposed Milestones $25 USD - Full Price

$25 USD 1 päivässä
(1 arvostelu)

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

$25 USD 0 päivässä
(2 arvostelua)
$25 USD 1 päivässä
(0 arvostelua)

hi Relevant Skills and Experience I have experience about this task if You give me this task i will surely finish i can try to keep the best relationship with you Proposed Milestones $15 USD - 1

$15 USD 1 päivässä
(1 arvostelu)
$25 USD 1 päivässä
(0 arvostelua)
$25 USD 1 päivässä
(0 arvostelua)

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

$10 USD 1 päivässä
(0 arvostelua)

A proposal has not yet been provided

$25 USD 15 päivässä
(0 arvostelua)

A proposal has not yet been provided

$35 USD 1 päivässä
(0 arvostelua)

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

$10 USD 0 päivässä
(0 arvostelua)