Dear friends,
I’m getting error in the formula below:

=IF(Information!$B$1="","",IF(OR(Information!$B$1="Std. 9 A",Information!$B$1="Std. 9 B"),=(COUNTIF(i8:i100,">=7") + COUNTIF(i8:i100,"<7")),=(COUNTIF(j8:j100,">=7") + COUNTIF(j8:j100,"<7"))))
If the cell on information sheet $b$1 contains ‘Std. 9 A or Std. 9 B’ then I want the formula for column ‘I’ else a formula for column ‘J’.

Any help will be appreciated.

Thanking you,