View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sarahz11 sarahz11 is offline
external usenet poster
 
Posts: 3
Default If, then statements

Hi all, thanks for your help! I have two columns of 10 cells each that will
have percentages in them (already calculated). My results cell needs to say
"yes" if 90% or greater of these cells (18 out of 20) show =50%, "no" if 90%
of the cells show <50%. Also, the rows of cells are not next to each other,
they are D27:D36 and F27:F36. And sometimes F27:F36 will not have any results
in it (it will be "N/A"). Am I trying to do too much? Thanks!!!!