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
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