View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
a a is offline
external usenet poster
 
Posts: 3
Default 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?