View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cindi Cindi is offline
external usenet poster
 
Posts: 22
Default Cumbersome IF Statement

I have several cells involved in this IF statement. I've tried to do a
SUMIF, but I can't get it to work. Can someone help me please?

=IF($I$33="No",(+H33*D50))+IF($I$33="Yes",0)+IF($I $34="No",(+H34*D50))+IF($I$34="Yes",0)+IF($I$35="N o",(+H35*D50))+IF($I$35="Yes",0)+IF($I$36="No",(+H 36*D50))+IF($I$36="Yes",0)+IF($I$37="No",(+H37*D50 ))+IF($I$37="Yes",0)+IF($I$38="No",(+H38*D50))+IF( $I$38="Yes",0)+IF($I$39="No",(+H39*D50))+IF($I$39= "Yes",0)+IF($I$40="No",(+H40*D50))+IF($I$40="Yes", 0)+IF($I$41="No",(+H41*D50))+IF($I$41="Yes",0)+IF( $I$43="No",(+H43*D50))+IF($I$43="Yes",0)+IF($I$56= "No",(+H56*D50))+IF($I$56="Yes",0)+IF($I$57="No",( +H57*D50))+IF($I$57="Yes",0)+IF($I$58="No",(+H58*D 50))+IF($I$58="Yes",0)
--
Cindi H