ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   recursive formula question (https://www.excelbanter.com/excel-worksheet-functions/141936-recursive-formula-question.html)

a

recursive formula question
 
For an array like:

893.0186
985.561
1045.56
1154.58
1271.604
1272.623

....


I want to check if any two of it sums to one member of it, i.e. the 2nd
column

893.0186
985.561 1878.579
1045.56 1938.583
1154.58 2047.594
1271.604 2164.622
1272.623 2165.642

....

How to write a single formula to check the condition? I can stupidly write a
formula and change it each column for calculation, but just don't know how
to check the difference (e.g. -10 < 893.0186+985.561 - 1870.1 < 10)

Could anybody help?




All times are GMT +1. The time now is 12:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com