syntax of formula

=IF(OR(AP2="probable-pathogenic",AP2="pathogenic"),"Likely Pathogenic",IF(AP2="unknown","VUS", IF(AND(AO2="common_variation",OR(D2="autosomal dominant",D2="autosomal dominant and autosomal recessive",D2="autosomal recessive and autosomal dominant",D2="autosomal dominant, autosomal recessive",D2="autosomal recessive, autosomal dominant")),AND(AB2<0.01,"Unknown",IF(AND(AB2>0.01,OR(D2="autosomaldominant",D2="autosomal dominant and autosomal recessive",D2="autosomal recessive and autosomal dominant",D2="autosomal dominant, autosomal recessive",D2="autosomal recessive, autosomal dominant")),"Likely Benign", IF(AND(AO2="common_variation",AND(AB2<0.1,D2="autosomal recessive")),"Unknown",IF(AND(AB2>0.1,OR(D2="autosomal recessive")),"Likely Benign",""))))))

Is the above syntax correct? Thank you.

I hope this helps:

1. If statement: Probable-pathogenic OR pathogenic in column AP (clinvar_3-3-2014) = likely pathogenic in column AS (classify)
2. If statement: Unknown in column AP (clinvar_3-3-2014) = VUS in column AS (classify)
3. IF AND OR statement: If column AO (common_3-3-2014) = common variation AND D2 (Inheritence)= autosomal dominant OR autosomal dominant and autosomal recessive OR autosomal recessive and autosomal dominant OR autosomal dominant, autosomal recessive OR autosomal recessive, autosomal dominant AND AB (PopFreqMax)<0.01 Then AS (Classify) is Unknown
4. IF AND OR statement: If column AO (common_3-3-2014) = common variation AND D2 (Inheritence)= autosomal dominant OR autosomal dominant and autosomal recessive OR autosomal recessive and autosomal dominant OR autosomal dominant, autosomal recessive OR autosomal recessive, autosomal dominant AND AB (PopFreqMax)>0.01 Then AS (Classify) is Likely Benign
5. IF AND OR statement: If column AO (common_3-3-2014) = common variation AND AB (PopFreqMax) <0.1 AND column D (Inheritence) is autosomal recessive Then column AS (Classify) = Unknown
6. IF AND OR statement: If column AO (common_3-3-2014) = common variation AND AB (PopFreqMax) >0.1 AND column D (Inheritence) is autosomal recessive Then column AS (Classify) = Unknown

There are basically six different checks that are performed for the Classify column. Thank you for your help.

The PopFreq (0.1 or 0.01 values) are not always given and sometime the common variation may be there. So the formula takes that into account. Additionally, lets say the popfreq is <0.01 but is a common variation, the classify should be unknown, but without the common variation check a likely benign would result. I hope this helps. Thanks.