# 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

Tietoa työnantajasta:
( 40 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

## 17 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ä
(583 arvostelua)
8.2
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ä
(115 arvostelua)
6.4
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ä
(127 arvostelua)
5.8
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ä
(13 arvostelua)
3.5
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ä
(5 arvostelua)
3.0

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
xlbymalix

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

\$25 USD 1 päivässä
(1 arvostelu)
0.8
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ä
(2 arvostelua)
0.5
\$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
\$25 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
eliannyscgg

A proposal has not yet been provided

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

A proposal has not yet been provided

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