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 los freelancers están ofertando un promedio de $23 para este trabajo.
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