Thread: Macro question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pawan Pawan is offline
external usenet poster
 
Posts: 87
Default Macro question

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