Macro question

  • Thread starter Thread starter Pawan
  • Start date Start date
P

Pawan

Hi

I have following requirement:

I have four numbers 2, 8, 10 and 11. I have one equation:

(n1+n2)*n3+n4

I have to find out result of this equation for all combinations of numbers.

There will be total 16 such combinations and results. But how can I do it in
macro. I can write a6 conditions, but do not want to do it. Is there any
other method to do this?

Thank you in advance.

Regards,
prm
 
Hi,

Before attempting this we need to be clear on the question

2, 8, 10, 11

Of these numbers there is 1 Combination and 24 permutations so which 16 of
the 24 permutations are we to use or am I misunderstanding the question?

Mike
 
We have to find all possibilities.. e.g.

(n1+n2)*n3+n4

n1 will assume all possible values and at the same time all other variables
will too... any number can be at any place at any given time and we need to
find result for all such possibilities
 
Back
Top