Need a function in Excel spreadsheet that would check to see if a sum of any combination of a specified range of cells within a column falls into a small range or values or is an exact match to a specified cell value (in dollars).
Example: cell range - B5:B13, values are -
<colgroup> <col width="106" /></colgroup>
| $1,682.00 |
| $2,360.06 |
| $22,241.22 |
| $24,546.72 |
| $36,717.78 |
| $77,174.55 |
| $137,953.50 |
| $181,248.34 |
| $562,874.56 |
Need to verify if a sum of any combination of cells from B5:B13 range matches and/or falls into specified range (1-2%) around
<colgroup> <col width="134" /></colgroup> | $925,047.40 |
Please let me know if you need further clarification.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
Windows XP with Office XP