View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sernst sernst is offline
external usenet poster
 
Posts: 2
Default Need to add to nested IF

I'm brain dead and tired of looking at this.

I need to add this primary condition: IF($BH11=0,0,...
to this formula:

=IF(OR($S11="7000",$S11="8000",AND($S11="1000",$R1 1<=0.001),AND($S11="1000",$D$7="Y")),IF(AND($S11=" 1000",$D$7="Y"),$C$7,21),IF($S11="1000",IF($R11<1, 90,IF($R11<5,75,IF($R11<10,50,IF($R11<25,35,IF($R1 1<40,30,IF($R11<80,20,15)))))),0))

Thanks in advance for any help.