In Progress

OpenOffice formula work

I have a spreadsheet in ods format.

The goal is to compare two numbers against each other, that are within 5.

i.e 5 and 9

i.e 5 and 10

not 5 and 11

The issue is that the data changes, so need a formula that will be consistent, when the data changes.

I've uploaded two examples with different formulas, you can use it and build your own.

Both examples are not perfect, but I need it to be perfect.

The position of the cells must not change only the formulas.

Skills: Excel

See more: display spreadsheet webpage format, description work completed spreadsheet, shift work roster spreadsheet, spreadsheet label format, owc11 spreadsheet xls format, work performed spreadsheet, vba work excel spreadsheet, work outsourcing spreadsheet, spreadsheet date format

About the Employer:
( 178 reviews ) Melbourne, Australia

Project ID: #14909120

Awarded to:

RafaelSch

Hi! I can do what you need both in OpenOffice and MSExcel quite easily. All you need is a review of the "match" formula. Waiting for your contact if you want any more information. Relevant Skills and Experience Stron More

$10 USD in 1 day
(1 Review)
0.1

18 freelancers are bidding on average $23 for this job

cgullapalli

Hi, I am good at Excel and formulas in open office. I just checked the description and would be a pleasure to assist you on your project. Looking forward to discuss in the chat. -Chandra Relevant Skills and Experience More

$34 USD in 0 days
(497 Reviews)
7.5
humayoonsheikh4u

Dear I have go through your project requirement in detail and willing to do it as per your requirements by applying advanced excel formulas. Best regards Humayoon Relevant Skills and Experience Excel

$25 USD in 1 day
(8 Reviews)
3.9
prakash1317

I have done similar projects & confident to assist you. I'll take responsibility to complete the work accurately & on time. You can trust my work and award this project to start from now. Thanks Relevant Skills and Ex More

$40 USD in 1 day
(7 Reviews)
3.2
Youssefaa

p Relevant Skills and Experience b Proposed Milestones $25 USD - b

$25 USD in 1 day
(6 Reviews)
3.2
$20 USD in 1 day
(0 Reviews)
0.0
$30 USD in 2 days
(0 Reviews)
0.0
$15 USD in 1 day
(0 Reviews)
0.0
rmblitz14

Hi! I can give it to you ASAP.

$20 USD in 1 day
(0 Reviews)
0.0
Johns643212

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0
waelhaiba

A proposal has not yet been provided

$10 USD in 1 day
(0 Reviews)
0.0
Tajintq

Hey,I'm VA and Web Researcher. I'm Really interested in this [url removed, login to view] you need accurate work in low rate,you can knock [url removed, login to view] keep faith on my words Waiting for your massage Regards,Towfiq Relevant Skills and Experience More

$25 USD in 1 day
(0 Reviews)
0.0
skhutashvili

A proposal has not yet been provided

$28 USD in 5 days
(0 Reviews)
0.0
monicadelc

A proposal has not yet been provided

$30 USD in 3 days
(0 Reviews)
0.0
maulikaparikh

Hello Sir, I m Maulika from India having superior experience in Data entry. Expert in excel with high speed. I can make it done asap.

$30 USD in 2 days
(0 Reviews)
0.0
luisric4rdo

$20 per work Habilidades y experiencia relevante excel teacher work Htos propuestos $20 USD - done

$20 USD in 1 day
(0 Reviews)
0.0
saharul111

Proposed Milestones $25 USD - Default milestone.

$25 USD in 1 day
(0 Reviews)
0.0
mhfsha

I can do this project perfectly if you need a perfect project please contact me

$10 USD in 1 day
(0 Reviews)
0.0