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.
18 freelancers are bidding on average $23 for this job
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
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