Find Jobs
Hire Freelancers

Create a google sheet's formula

$10-30 USD

Completed
Posted over 3 years ago

$10-30 USD

Paid on delivery
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
Project ID: 26952310

About the project

13 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

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:
User Avatar
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 great work for you and ensure your quality.
$20 USD in 7 days
4.9 (405 reviews)
7.8
7.8
13 freelancers are bidding on average $20 USD for this job
User Avatar
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 in 1 day
4.9 (272 reviews)
6.8
6.8
User Avatar
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 excellent solutions. You can refer my freelancer profile for reviews and completed tasks: https://www.freelancer.com/u/kevivu.html Expert in MS Office/Google GSuite / VBA(Macros)/ GScript / Access/Excel/Word/Outlook/ PYTHON/VBA/VB/.NET/WEB Servies/SOAP/REST/API / SQL Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, converting Raw data to structured report, sales dashboard, PO tracking, Invoice Automation, budgeting, profitability, estimation, time management dashboards, etc. Charts, formatting, templates, dashboard, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Looking forward to work with you.. Have a nice day Thank you
$30 USD in 1 day
4.9 (81 reviews)
6.1
6.1
User Avatar
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 and understand your requirements. I can complete this work with high quality. Message me for more discussion. Thank you.
$15 USD in 5 days
4.9 (12 reviews)
4.3
4.3
User Avatar
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 talented and very hard working also know the value of time so, always try to deliver work on time. My motive is to make my employer happy with quality of service. If you are looking for data entry work, I hope to deliver you the best of best services. "
$19 USD in 1 day
5.0 (18 reviews)
4.2
4.2
User Avatar
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 google sheet's formula". I have deep knowledge of macros and did several jobs of macros with 5+ rating. I am quoting low price because I want to built portfolio here at freelancer.com. You can message me. I can assist you in best way & I have done several projects Google Sheets & Scripts. It. It includes extracting information from text files, websites, transferring info in to excel, User forms, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet, etc. I have also handled various Excel tasks. It includes the creation of formulas using arrays, Pivot table creation, Creation of graphs, filtering, removing duplicates, Data analysis etc. Let's initiate quick chat and discuss together. I would be happy to answer any queries that you may have Best Regards, MBY
$20 USD in 1 day
5.0 (18 reviews)
3.5
3.5
User Avatar
"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 hour only. Just award this to me for a quality and clean output with 100% accuracy.
$30 USD in 1 day
4.9 (15 reviews)
3.1
3.1
User Avatar
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. Please send your message so that we can discuss about your project
$20 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 TRACK OF ANYTHING THAT OCCURS WITHIN YOUR BUSINESS. MY SERVICE PROFESSIONAL WRITER OF BLOGS/ARTICLES EXPERT IN TRANSLATIONS IN MANY LANGUAGES DATA ENTER EXPERT WORK IN GOOGLE DOC/SHEET PROOFREADING WEB SCARPING CLICKABLE EMAIL SIGNATURE WORD, EXCEL, POWERPOINT PRESENTATION E-COMMERCE/LISTINGS MANAGEMENTS DATA SCRAPING COPY AND PASTE DATA MINING PDF TO EXCEL/JPEG TO EXCEL MARKET RESEARCH PRODUCT RESEARCH WEB RESEARCH SOCIAL MEDIA WORDPRESS WEBSITE EDITING TYPING FROM PDF TO WORD PRODUCT LISTING SEO KEYWORD RESEARCH & COMPETITOR ANALYSIS ADD A LOT MORE
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Etobicoke, Canada
5.0
106
Payment method verified
Member since Aug 12, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.