i do not profess to be experienced ... however here is my formula ...

=IF(E2=0,"",IF(B4=0,"",IF(P2>2,(E3*90%*B4*E2),(E3*100%*B4*E2))))

the problem is that out of 13 columns (and three columns of totals) in which i have established the math correctly and everything works, BUT ...

there are 7 columns which must apply 100% to ONLY THE FIRST TWO when they are selected ... i cannot figure out how to tell these columns to apply 100% to only the first two ... hope this makes sense to someone ... thanks in advance for any help i receive!