View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SpecialK SpecialK is offline
external usenet poster
 
Posts: 5
Default Excel 2007 - Multiple If Then or Lookup

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