samsilverman
Board Regular
- Joined
- Nov 9, 2009
- Messages
- 176
I am using excel 2007:
I have created the following formula (with some help from this forum), but I am getting an error message saying I am missing a left or right parentheses. Can someone help me? I can't figure it out.
=IF(ISBLANK(B17),"",IF(AND($I$8="AIRBORNE ISOLATION",L17<=-0.01,OR(AND(M17="",L18=""),AND(M17="",L18<=-0.0001,(I18+J18)>0,F18="",G18=""),AND(M17="",L18<=-0.0001,(I18+J18)>0,(F18+G18)>0,(I18+J18)>(F18+G18),AND(M17<=-0.01,L18<=-0.0001,(I18+J18)>0,F18="",G18=""),<o></o>AND(M17<=-0.01,L18<=-0.0001,(I18+J18)>0,(F18+G18)>0,(I18+J18)>(F18+G18))),"",IF(AND($I$8="PROTECTIVE ENVIRONMENT",L17>=0.01,OR(AND(M17="",L18=""),AND(M17="",L18=0,(F18+G18)>0,I18="",J18=""),AND(M17="",L18<0,(I18+J18)>0,F18="",G18=""),AND(M17>=0.01,L18=0,(F18+G18)>0,I18="",J18=""),AND(M17>=0.01,L18<0,(I18+J18)>0,F18="",G18=""))),"",1)))<o></o>
I have created the following formula (with some help from this forum), but I am getting an error message saying I am missing a left or right parentheses. Can someone help me? I can't figure it out.
=IF(ISBLANK(B17),"",IF(AND($I$8="AIRBORNE ISOLATION",L17<=-0.01,OR(AND(M17="",L18=""),AND(M17="",L18<=-0.0001,(I18+J18)>0,F18="",G18=""),AND(M17="",L18<=-0.0001,(I18+J18)>0,(F18+G18)>0,(I18+J18)>(F18+G18),AND(M17<=-0.01,L18<=-0.0001,(I18+J18)>0,F18="",G18=""),<o></o>AND(M17<=-0.01,L18<=-0.0001,(I18+J18)>0,(F18+G18)>0,(I18+J18)>(F18+G18))),"",IF(AND($I$8="PROTECTIVE ENVIRONMENT",L17>=0.01,OR(AND(M17="",L18=""),AND(M17="",L18=0,(F18+G18)>0,I18="",J18=""),AND(M17="",L18<0,(I18+J18)>0,F18="",G18=""),AND(M17>=0.01,L18=0,(F18+G18)>0,I18="",J18=""),AND(M17>=0.01,L18<0,(I18+J18)>0,F18="",G18=""))),"",1)))<o></o>