Write a short Google Sheets formula

$10-30 USD

Completed

Posted

over 6 years ago

$10-30 USD

Paid on delivery

Write a single Google Sheets formula that contains ALL of the following logic: IF $F$4 AND $G$4 = No then fill the cell with the text "Awaiting Promotion Request" OR IF $F$4 AND $G$4 = Yes then fill the cell with the text "Scheduled" OR IF $F$4 = Yes AND $G$4= No then fill the cell with the text "Awaiting Promotion Request" OR IF $F$4 = No AND $G$4 = Yes then fill the cell with the text "Pending Review" The result should be a formula and not a script.

Excel

Project ID: 15069198

About the project

10 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@cgullapalli

Hi, I am good at Google formulas. I can provide a single formula. It would be a pleasure to assist you on your project. Looking forward to discuss in the chat. -Chandra Relevant Skills and Experience Formulas in google sheets Proposed Milestones $10 USD - Milestone

$10 USD in 0 day

5.0

(612 reviews)

7.6

10 freelancers are bidding on average $21 USD for this job

@schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have the 5 years of experience with excellent knowledge. please give me a chance to work on your project Proposed Milestones $30 USD - Payment once project is complete

$30 USD in 1 day

4.9

(209 reviews)

7.2

@narsim3128

With respect to this project I would like to present myself as a candidate for your consideration. I have more than 8 years of IT experience. I have successfully completed few projects Relevant Skills and Experience Excel(Advanced) Proposed Milestones $30 USD - This task will be completed within schedule

$30 USD in 1 day

4.9

(36 reviews)

5.0

@samanabbad

Hi.I have done Masters in Business and IT.I understand the job description and will be able to put data in the google sheets.I believe in quality work and in client satisfaction. Relevant Skills and Experience I have expertise in Excel and I have the ability to put the formulas accurately. Proposed Milestones $25 USD - work no

$25 USD in 1 day

4.8

(3 reviews)

3.0

@Sundaram87

Hi I understood your required formula. I have experience in excel formulas such as ifs, countif, sumif, index, match, etc. I can complete it within hour. Thanks Sundaram Relevant Skills and Experience Excel Proposed Milestones $15 USD - After completion

$15 USD in 0 day

3.8

(8 reviews)

2.3

@asohaib1212

Sir i'm interested in your project.. I’m a strategic MS Office,Data Entry,editor, writer. Relevant Skills and Experience For 5 years I’ve worked in Copywriting, Web Scraping, Web Search, MS World, MS Excel,Data Entry,Office Management,,Data Entry Clerk. Proposed Milestones $10 USD - 5$ only for complete project....

$10 USD in 1 day