Tamamlanmış

Create a google sheet's formula

Hello.

I have a google sheets and one cell requires a conditional formatting. I need someone who is knowledgeable in google sheets to create this formula for me. I should be very simple for someone who know what they are doing. I need someone to work right away.

This is the formula that i want:

IF CELL D2 > 0 AND SUM OF CELLS (M2,N2,02) < 0.00, THEN FILL CELL Q2 IN RED AND PUT TEXT "CHECK" IN CELL Q2

IF CELL D2 > 0 AND SUM OF CELLS (M2,N2,02) > 0.00, THEN FILL CELL Q2 IN GREEN AND PUT TEXT "GOOD" IN CELL Q2

IF CELL D2 < 0 AND SUM OF CELLS (M2,N2,02) < 0.00, THEN FILL CELL Q2 IN GREEN AND PUT TEXT "NO INVENTORY" IN CELL Q2

IF CELL D2 < 0 AND SUM OF CELLS (M2,N2,02) > 0.00, THEN FILL CELL Q2 IN GREEN AND PUT TEXT "NO INVENTORY" IN CELL Q2

Beceriler: Excel, Veri Girişi, Veri İşleme, Matematik, Google Sheets

Daha fazlasını gör: create google news sitemap, create google street map, create data sheet, create module sheet, hello create cool logo templates, create google calendar view, create sell sheet illustrator, create log sheet, create google calendar aspnet vbnet, create log sheet net, create google base xml feed, create google adwords keywords automatically, create google map application, create attendance sheet visual basic, create google map mysql data, create access sheet, create google gadget

İşveren Hakkında:
( 104 değerlendirme ) Etobicoke, Canada

Proje NO: #26952310

Seçilen:

datakillers

Hi,"I am an Excel Expert with Professional experience working with Excel. I have more than 10 year experince with excel. Complete a lot of jobs on Freelancer with highly satisfaction of client. I believe I can do a gre Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 20%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(382 Değerlendirme)
7.7

Bu iş için 14 freelancer ortalamada $20 teklif veriyor

(955 Değerlendirme)
8.1
(254 Değerlendirme)
7.2
(255 Değerlendirme)
7.2
mrbrave

Hi, Get it done now. I am expert in Google sheets with over 8 years of experience. I can complete this functionality within few minutes. Available right away to work.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(268 Değerlendirme)
6.8
kevivu

Hi There, I have reviewed your requirement and I can definitely start immediately. Also I am 100% available during EST hours. I worked on numerous similar projects in the past and always impressed the clients with my Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(78 Değerlendirme)
6.0
superseoservice

Hi there, I would like to work on your project and want to be discussions. I have 4+ years of experience in the field. I can start working immediately on this project if needed. I have gone through the job description Daha Fazla

$15 USD in 5 gün içinde
(12 Değerlendirme)
4.3
Datasolution4you

Hi, I have read your project description and I feel I will be right choice for you for this project. I am certified from ALISON for Microsoft Office specially Excel and Formula, Word and Access Database. I am talente Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(14 Değerlendirme)
4.0
Manishnsingh

"I will complete this in next 2 hours" Hi there, I am good with excel and google sheet related task. I have completed a number of projects before also and plenty of experience for this. Will complete this in next 2 hou Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(12 Değerlendirme)
3.1
yadavexpert53

Dear Employer, Nested If condition (If then else formula). I am an expert in conditional formatting and excel formulas. I understood what you need. You can message me. I would like to help in the project "Create a go Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(9 Değerlendirme)
2.7
mahadi3008

Dear sir, Hope you are doing well! I have enough ability to meet your needs. I have 7+ years’ experiences so I can show my top skill through this project. I would like to discuss about your project with you via chat. P Daha Fazla

$20 USD in 2 gün içinde
(0 Değerlendirme)
0.0
jkevz27

I am a certified Excel VBA developer. I can create any macro codes that can make the project easier and faster to finish.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
sidvinak9

HI, THIS IS VIBHA SHARMA I’M A FREELANCER PROFESSIONAL VIRTUAL ASSISTANT WITH 9 YEARS EXPERIENCE. I WILL DO ANY VIRTUAL ASSISTANT JOBS THAT YOU REQUIRE. I WILL ALWAYS KEEP IN CONTACT WITH YOU SO THAT YOU DO NOT LOSE TR Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
sendsla

hi, do this -> open google sheet. go to format -> conditional formatting... and then setup the rules. I can help you out or event just do it for you Looking forward to hear from you Simon https://simonberinglarsen.g Daha Fazla

$15 USD in 7 gün içinde
(0 Değerlendirme)
0.0