R
Rick
The following express gave the condition of 100% when $ was missing, and when
added it gave a 0%, any reasons why?
=IF(OR($G5="C",$G5="M"),IF(OR($O5=0,SUM($I5-$J5=0)),"",IF($G5="M",0.8,IF(YEAR($B5)=$AU$3,1,IF(OR($F5="Full",$F5="BMP",$F5="CBC",$F5="HFP",$F5="LP",$F5="RVP",$F5="UA"),1,IF(OR(AND($H5="D",$A5>=RollUp!$AX$15,$C5>=RollUp!$AY15),AND($H5="S",$A5>=RollUp!$AX$16,$C5>=RollUp!$AY16)),1,0.8))))),"")
IF(OR(AND($H5="D",$A5>=RollUp!$AX$15,$C5>=RollUp!$AY$15),AND($H5="S",$A5>=RollUp!$AX$16,$C5>=RollUp!$AY$16)),1,0.8))))),"")
added it gave a 0%, any reasons why?
=IF(OR($G5="C",$G5="M"),IF(OR($O5=0,SUM($I5-$J5=0)),"",IF($G5="M",0.8,IF(YEAR($B5)=$AU$3,1,IF(OR($F5="Full",$F5="BMP",$F5="CBC",$F5="HFP",$F5="LP",$F5="RVP",$F5="UA"),1,IF(OR(AND($H5="D",$A5>=RollUp!$AX$15,$C5>=RollUp!$AY15),AND($H5="S",$A5>=RollUp!$AX$16,$C5>=RollUp!$AY16)),1,0.8))))),"")
IF(OR(AND($H5="D",$A5>=RollUp!$AX$15,$C5>=RollUp!$AY$15),AND($H5="S",$A5>=RollUp!$AX$16,$C5>=RollUp!$AY$16)),1,0.8))))),"")