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.
|