![]() |
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