Using And/If/Or Formulas Functions

2) If Days to good (Column 'R') is between 31 and 60 AND Total DP Perc (Column 'AK') is "<.10" AND Status (Column 'U') is not (X,T) then calculate Sales Volume (Column 'H'), if not then 0

=IF( AND( R2>=31, R2<=60, AK2 <0.1, OR(U2<>"X", U2<>"T")), H2, 0)

1) If Days to Good (Column 'R') is "<=30" OR Type Code (Column 'P') is "P" AND Total DP Perc (Column 'AK') is ">=0.1" OR Days to Good (Column 'R') "<30" AND Total DP Perc (Column 'AK') ">=.10" AND Status (Column 'U') is not (X,T) - Then calculate sales volume (Column 'H') if not then 0

=IF( AND ( AK >= 0.1, OR(R2 <=30 , P2="P") , OR(U2<>"X", U2<>"T") ) , H2, 0)

combining the two
=IF( OR(AND( R2>=31, R2<=60, AK2 <0.1, OR(U2<>"X", U2<>"T")), AND ( AK >= 0.1, OR(R2 <=30 , P2="P") , OR(U2<>"X", U2<>"T") ) ) , H2, 0)

your welcome
thanks for the rep