Thanks for your help Jacob...I appreciate it.


"Jacob Skaria" wrote:

Hi "SpecialK"

Try the below formula ...with 10%. Adjust the % as required.

=IF(COUNTIF(K5:K9,"x")=0,0,((H5*0.1)+I5)*IF(K10="X ",0.95,1))

If this post helps click Yes
---------------
Jacob Skaria


"SpecialK" wrote:

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