Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 59
Default Look for a certain type of formula...

Does a formula exist that can search through a list of numbers and tell you
if any certain combination, whether adding or subtracting numbers in that
list, will provide you with a target number. For instance, say I have a list
of 100 random number and I'm trying to see if any of them, if added or
subtracted with each other, can give me a final value of some other number
that I'm looking for. If you need clarification on what I'm trying to
achieve here, just let me know.

Thanks,

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 41
Default Look for a certain type of formula...

If you hold your operation to working with 2 terms at time and consider only
two operators, + and -, you'll have 200,000 possible sums and differences.
If you broaden your effort and allow 3 terms at a time, and allow all +,
allow all -, and then allow either + or -, you're well over a million
possible solutions.

The chances of any integer that you can think of, smaller than a million
being generated in this effort are so darn high, it seems like a futile
effort to me...

"Jimmy" wrote:

Does a formula exist that can search through a list of numbers and tell you
if any certain combination, whether adding or subtracting numbers in that
list, will provide you with a target number. For instance, say I have a list
of 100 random number and I'm trying to see if any of them, if added or
subtracted with each other, can give me a final value of some other number
that I'm looking for. If you need clarification on what I'm trying to
achieve here, just let me know.

Thanks,

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 59
Default Look for a certain type of formula...

ConfusedNHouston,

I'm not quite sure I understand what you're saying. I'm not saying that
you're wrong, but could you word it in somewhat simpler terms or perhaps give
an example of why it wouldn't work.

I'm not sure if you're saying that I would get too many solutions or that
the calculation would be too processor intensive.

Let me know.

Thanks,

Jimmy

"ConfusedNHouston" wrote:

If you hold your operation to working with 2 terms at time and consider only
two operators, + and -, you'll have 200,000 possible sums and differences.
If you broaden your effort and allow 3 terms at a time, and allow all +,
allow all -, and then allow either + or -, you're well over a million
possible solutions.

The chances of any integer that you can think of, smaller than a million
being generated in this effort are so darn high, it seems like a futile
effort to me...

"Jimmy" wrote:

Does a formula exist that can search through a list of numbers and tell you
if any certain combination, whether adding or subtracting numbers in that
list, will provide you with a target number. For instance, say I have a list
of 100 random number and I'm trying to see if any of them, if added or
subtracted with each other, can give me a final value of some other number
that I'm looking for. If you need clarification on what I'm trying to
achieve here, just let me know.

Thanks,

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I type 2 effictive formula in one cell? Aiman Arafat Excel Worksheet Functions 2 March 8th 06 01:17 PM
Formula Problem - interrupted by #VALUE! in other cells!? Ted Excel Worksheet Functions 17 November 25th 05 05:18 PM
How to type correctly formula in calculated field in a pivot? louloutte48 Excel Worksheet Functions 2 June 28th 05 01:46 PM
The { formula } type of formula Alex Excel Worksheet Functions 7 June 17th 05 09:06 PM
How to I use ** without Excel thinking I want to type a formula? Buff Excel Discussion (Misc queries) 2 December 22nd 04 09:31 PM


All times are GMT +1. The time now is 05:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"