formula criteria

[cmccabe]

Please Login or Register  to view this content.

The above formula works great, but I would like to add some criteria to it and seem to be having trouble with the syntax.

The first criteria is an OR statement AL2="common_variation",“Likely Benign” for both sets of IF's

The second criteria is another IF statement AM2=”likely pathogenic OR AM2=”pathogenic” =”Likely Pathogenic”

The third criteria is also an IF statement AM2=”unknown” =”VUS”

Thank you.

[Richard Buttrey]

Hi,

You'll need to tell us the order of precedence for all these Additional IF /OR statements WITH RESEPECT TO the original Ifs.

[cmccabe]

Hello,

I placed the criteria in bold in the formula.

Please Login or Register  to view this content.

I hope this is what you need. Thank you.