Consulting

Results 1 to 2 of 2

Thread: Write this formula in a shorter way

  1. #1
    VBAX Contributor
    Joined
    Mar 2009
    Location
    Porto, Portugal
    Posts
    180
    Location

    Write this formula in a shorter way

    Hi Folks

    I have this formula and I wish It would be a way to make it shorter, particulary the bold part. Is it possible?

    =IF($I112="";0;IF($U112>0;ROUND((IF(AND(AA$38>=$V112;AA$38<$W112);1;0)+IF(AND(AA$39>=$V112 ;AA$39<$W112);1;0)+IF(AND(AA$40>=$V112;AA$40<$W112);1;0)+IF(AND(AA$41>=$V11 2;AA$41<$W112);1;0)+IF(AND(AA$42>=$V112;AA$42<$W112);1;0)+IF(AND(AA$43>=$V1 12;AA$43<$W112);1;0)+IF(AND(AA$44>=$V112;AA$44<$W112);1;0))*($I112/$U112);2);0))

    Thanks in advance
    Ioncila
    Last edited by ioncila; 08-06-2010 at 03:49 AM.

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Try

    =IF($I112="";0;IF($U112>0;ARRED(SOMARPRODUTO (--($AA$38:$AA$44>$V$112);--($AA$38:$AA$44<$W$112))*($I112/$U112);2);0))
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

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