Færdiggjort

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

Evner: Excel, Dataindførsel, Databehandling, Matematik, Google Sheets

Se mere: 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

Om arbejdsgiveren:
( 104 bedømmelser ) Etobicoke, Canada

Projekt ID: #26952310

Tildelt til:

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 Flere

$20 USD in 7 dage
(382 bedømmelser)
7.7

14 freelancere byder i gennemsnit $20 på dette job

(955 bedømmelser)
8.1
(254 bedømmelser)
7.2
(255 bedømmelser)
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.

$15 USD på 1 dag
(268 bedømmelser)
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 Flere

$30 USD på 1 dag
(78 bedømmelser)
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 Flere

$15 USD in 5 dage
(12 bedømmelser)
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 Flere

$19 USD på 1 dag
(14 bedømmelser)
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 Flere

$30 USD på 1 dag
(12 bedømmelser)
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 Flere

$20 USD på 1 dag
(9 bedømmelser)
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 Flere

$20 USD in 2 dage
(0 bedømmelser)
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.

$10 USD på 1 dag
(0 bedømmelser)
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 Flere

$10 USD på 1 dag
(0 bedømmelser)
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 Flere

$15 USD in 7 dage
(0 bedømmelser)
0.0