| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find cause of slowly calculating spreadsheet -recursive equation? | Excel Discussion (Misc queries) | |||
| close workbook without closing excel and stop recursive function | Excel Discussion (Misc queries) | |||
| Recursive Functio help | Excel Worksheet Functions | |||
| Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
| recursive sums | Excel Worksheet Functions | |||
Linear Mode
