PDA

View Full Version : Write this formula in a shorter way



ioncila
08-06-2010, 02:46 AM
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>=$V112;AA$41<$W112);1;0)+IF(AND(AA$42>=$V112;AA$42<$W112);1;0)+IF(AND(AA$43>=$V112;AA$43<$W112);1;0)+IF(AND(AA$44>=$V112;AA$44<$W112);1;0))*($I112/$U112);2);0))

Thanks in advance
Ioncila

Bob Phillips
08-06-2010, 04:17 AM
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))