Find Jobs
Hire Freelancers

Modify spreadsheet

$10-30 USD

Завершено
Опублікований almost 6 years ago

$10-30 USD

Оплачується при отриманні
I have a spreadsheet in google that is used for scoring athletic competitions. I'm still having a few problems and can't figure it out. Specifically, zero scores aren't figured properly. If "high" is selected then [login to view URL] is ascending and everything works fine. If "low" is selected then [login to view URL] is descending and zeros are not figured into the number of results. A result of 0 should get a score of 0. If I change the formula to "=IF(H18>=0. . ." then all the 0 results get a score of 1. Also, empty cells get scores, which I'd rather not get scores. I18 should be 2 instead of 1, I19 should be 3 instead of 2, and I20 should get a 0. If I change the formula to H18>=0, then empty cells get scores. Empty cells should not get a score. Freelancer will provide new formula to correct this issue and apply formula to all sections properly. [login to view URL]
ID проекту: 17320579

Про проект

12 пропозицій(-ї)
Дистанційний проект
Активність 6 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
Доручений:
Аватарка користувача
I can do this easily. I have a spreadsheet in google that is used for scoring athletic competitions. I'm still having a few problems and can't figure it out. Specifically, zero scores aren't figured properly. If "high" is selected then [login to view URL] is ascending and everything works fine. If "low" is selected then [login to view URL] is descending and zeros are not figured into the number of results. A result of 0 should get a score of 0. If I change the formula to "=IF(H18>=0. . ." then all the 0 results get a score of 1. Also, empty cells get scores, which I'd rather not get scores. I18 should be 2 instead of 1, I19 should be 3 instead of 2, and I20 should get a 0. If I change the formula to H18>=0, then empty cells get scores. Empty cells should not get a score. Freelancer will provide new formula to correct this issue and apply formula to all sections properly. [login to view URL]
$10 USD за 1 день
5,0 (18 відгуки(-ів))
3,9
3,9
12 фрілансерів(-и) готові виконати цю роботу у середньому за $26 USD
Аватарка користувача
HI, I am good at Google sheets and formulas. I am referring the provided google sheet link. Looking forward to discuss the problem to get the complete scope of work. I can provide quick turnaround. -Chandra
$35 USD за 0 день
5,0 (1152 відгуки(-ів))
8,4
8,4
Аватарка користувача
Hi there..... Warm Greetings We came along with your request for Modify spreadsheet and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of Data Entry, Excel We have worked on 350+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !
$50 USD за 1 день
4,9 (491 відгуки(-ів))
8,4
8,4
Аватарка користувача
Hi, As you want corrections and rebuilding of your formulas in Excel sheet, I will do that for you. I have many years of experience in Excel,data analysis, pivots and VBA macros etc. I have finished many such projects. Please give me this opportunity to work on your project. Quality work with high accuracy and 100% customer satisfaction is guaranteed. Thanks, Peter
$30 USD за 2 дні(-в)
5,0 (100 відгуки(-ів))
6,5
6,5
Аватарка користувача
Hello, I am an experienced Data Analyst with advanced excel skills. I can deliver you quality work, Just give me the opportunity to show you what i can do. Thanks!
$40 USD за 1 день
4,9 (64 відгуки(-ів))
6,8
6,8
Аватарка користувача
Hi I am very much interested to do your work. I am experienced word, excel, spread sheet etc. I have to change some of your formula to make a successful result. Please check my profile. I am sincere and can do your work correctly.
$25 USD за 0 день
4,9 (17 відгуки(-ів))
4,4
4,4
Аватарка користувача
Hi there, i understand your requirement and can do the work perfectly using my outstanding experience. Please award me the project so that we discuss it more Thank you.
$20 USD за 1 день
4,9 (12 відгуки(-ів))
3,6
3,6
Аватарка користувача
Hello, Hope you are doing well. I am a web developer and I have more than five years of experience. I specialize in excel data processing, calculation, formula apply etc. I can do this work properly and able to apply the formula properly. I am committed to getting your job done with the best quality. Thanks Atiqur Rahman
$25 USD за 1 день
5,0 (3 відгуки(-ів))
3,2
3,2
Аватарка користувача
hi my name is andrew mikhail i can do this for u in less time and u will get a perfect work i can send u more than 1 sample ;)
$10 USD за 1 день
4,8 (14 відгуки(-ів))
3,4
3,4

Про клієнта

Прапор UNITED STATES
Pleasant Hill, United States
4,9
51
Спосіб оплати верифіковано
На сайті з лист. 8, 2004

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.