Consulting

Results 1 to 5 of 5

Thread: How to simplify vba code?

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    How to simplify vba code?

    1 2 3 4 5    
                 
    2 1 2 1 10 76 0.083333
    2 1 2 1 10 76 0.083333
    2 1 2 1 10 76 0.083333
    2 1 2 1 10 76 0.083333
    2 1 2 1 10 76 0.083333
    2 1 2 1 10 76 0.083333
    2 1 2 1 10 76 0.083333
    2 1 2 1 10 76 0.083333
    2 1 2 1 10 76 0.083333
    2 1 2 1 10 76 0.083333
    2 1 2 1 10 76 0.083333
    2 1 2 1 10 76 0.083333
              912 1

    ARRAY.xlsm
    I used three times of arrays in the worksheet to complete my work, may I ask someone to guide me to simplify this code?

    If a3>a1, a3*a1;
    If a3<a2,a3*a2*2 ..............


    76=a3*a1+b3*b1*2+c3*c1*2+d3*d1*2+e3*e1

    0.083333=76/912

    I hope it is clear.
    Last edited by idnoidno; 05-28-2017 at 06:47 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •