Below mentioned formula is working fine
=+IF(D7=E7,IF(AND(CT6>=85%,CT6<90%),3*30%*E7,IF(AND(CT6>=90%,CT6<100%),3*50%*E7,IF(AND(CT6>=100%,CT6<110%),3*100%*E7,IF(AND(CT6>=110%,CT6<125%),3*C7+3*120%*G7,IF(AND(CT6>=125%,CT6<140%),3*C7+3*140%*G7,IF(AND(CT6>=140%,CT6<150%),3*C7+3*150%*G7,"")&IF(AND(CT6>=150%),3*C7+3*160%*G7,"")))))))
and
Below mentioned formula is not working
=+IF(AND(CT6>=85%,CT6<90%,CU6=FALSE,CV6>=0%,CV6<100%),SUM(3*30%*E7,3*15%*F7),IF(AND(CT6>=90%,CT6<100%,CU6=FALSE,CV6>=0%,CV6<100%),SUM(3*50%*E7,3*25%*F7),IF(AND(CT6>=100%,CU6=FALSE,CV6>=0%,CV6<100%),SUM(3*100%*E7,3*50%*F7),IF(AND(CT6>=100%,CU6=FALSE,CV6>=100%,CV6<110%),SUM(3*100%*E7,3*50%*F7),IF(AND(CT6>=100%,CU6=FALSE,CV6>=110%,CV6<125%),SUM(3*C7,3*50%*F7,3*120%*G7),IF(AND(CT6>=100%,CU6=FALSE,CV6>=125%,CV6<140%),SUM(3*C7,3*50%*F7,3*140%*G7),IF(AND(CT6>=100%,CU6=FALSE,CV6>=140%,CV6<150%),SUM(3*C7,3*50%*F7,3*150%*G7,""))))&IF(AND(CT6>=100%,CU6=FALSE,CV6>=150%),SUM(3*C7,3*50%*F7,3*160%*G7,""))))))
can anyone help me in this regard.
Thanks in advance.
=+IF(D7=E7,IF(AND(CT6>=85%,CT6<90%),3*30%*E7,IF(AND(CT6>=90%,CT6<100%),3*50%*E7,IF(AND(CT6>=100%,CT6<110%),3*100%*E7,IF(AND(CT6>=110%,CT6<125%),3*C7+3*120%*G7,IF(AND(CT6>=125%,CT6<140%),3*C7+3*140%*G7,IF(AND(CT6>=140%,CT6<150%),3*C7+3*150%*G7,"")&IF(AND(CT6>=150%),3*C7+3*160%*G7,"")))))))
and
Below mentioned formula is not working
=+IF(AND(CT6>=85%,CT6<90%,CU6=FALSE,CV6>=0%,CV6<100%),SUM(3*30%*E7,3*15%*F7),IF(AND(CT6>=90%,CT6<100%,CU6=FALSE,CV6>=0%,CV6<100%),SUM(3*50%*E7,3*25%*F7),IF(AND(CT6>=100%,CU6=FALSE,CV6>=0%,CV6<100%),SUM(3*100%*E7,3*50%*F7),IF(AND(CT6>=100%,CU6=FALSE,CV6>=100%,CV6<110%),SUM(3*100%*E7,3*50%*F7),IF(AND(CT6>=100%,CU6=FALSE,CV6>=110%,CV6<125%),SUM(3*C7,3*50%*F7,3*120%*G7),IF(AND(CT6>=100%,CU6=FALSE,CV6>=125%,CV6<140%),SUM(3*C7,3*50%*F7,3*140%*G7),IF(AND(CT6>=100%,CU6=FALSE,CV6>=140%,CV6<150%),SUM(3*C7,3*50%*F7,3*150%*G7,""))))&IF(AND(CT6>=100%,CU6=FALSE,CV6>=150%),SUM(3*C7,3*50%*F7,3*160%*G7,""))))))
can anyone help me in this regard.
Thanks in advance.