Suoritettu

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

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

Here is the transcription in excel of the Google Sheet

Here is the link that allow the small sheet to be viewed
https://docs.google.com/spreadsheets/d/131haglpmyzyZMB1lnzXpvczqtmoP9l2_FEsabysoEkQ/edit?usp=sharing

Taidot: Excel, Matematiikka

Näytä lisää: 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, script task copy data excel sheet, need create google account, copy data scanned sheet, create purchase order form google, create iphone app using google maps, create custom login page google app mail, create markers inside polygons google earth

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

Projektin tunnus: #15538304

Myönnetty käyttäjälle:

benji247

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)
0.0

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

jaylancer43

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

$34 USD 0 päivässä
(512 arvostelua)
8.0
rohitpithisaria

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ä
(104 arvostelua)
6.1
bilalmaher053

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ä
(62 arvostelua)
5.2
$25 USD 1 päivässä
(14 arvostelua)
4.1
haleem0786

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ä
(5 arvostelua)
2.2
nadeem7898

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)
2.6
Nemo2192

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ä
(2 arvostelua)
1.0
$25 USD 1 päivässä
(0 arvostelua)
0.0
eliannyscgg

A proposal has not yet been provided

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

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ä
(1 arvostelu)
0.0
baljeet0315

A proposal has not yet been provided

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

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)
0.0
xlbymalix

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

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

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)
0.0
Adina01

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)
0.0