Hi

I suppose that for each cells in K5:K9 there is the appropriate percentage
in the corresponding cell of L5:L9

=IF(COUNTIF(K5:K9,"x")=1,(I5+H5*SUMPRODUCT( (K5:K9="x")*(L5:L9))) *
(IF(K10="x",0.95,1)),"no percentage ")





"SpecialK" a écrit dans le message de
...
I'm trying to check cells K5 or K6 or K7 or K8 or K9 for the presence of
the
letter "x" and if "True" to multiply cell H5 by the appropriate percentage
and then add cell I5 to the total. Additionally, I need to simultaneously
check cell K10 for the letter "x" and if TRUE then the previous total
needs
to be multiplied by .95