Getting error #value

[mso3]

Hi,
If the cell '$b$1' = Std. 9 A or Std. 9 B' then the cell should show 'Hindi1' else 'Hindi2'. The formula is giving error #value.

=IF(Information!$b$1="","",IF(OR(Information!$b$1="Std. 9 A","Std. 9 B"),"Hindi1","Hindi2"))

Any help will be appreciated.

Thanking you,

[Glenn Kennedy]

Try this instead:

=IF(Information!$B$1="","",IF(OR(Information!$B$1="Std. 9 A",Information!$B$1="Std. 9 A""Std. 9 B"),"Hindi1","Hindi2"))

[mso3]

Hi Glenn,
Thank you for correction. It's partially working. If there is 'Std. 9 A or Std. 9 B' on information sheet $b$1 then the cell should display 'Hindi1' else 'Hindi2'. Now for Std. 9 B it is showing 'Hindi2' instead of 'Hindi1'.

Std. 9 A: Hindi1
Std. 9 B: Hindi1
Else: Hindi2

Thanking you.

[Glenn Kennedy]

Sorry... Clumsy copying by me..

=IF(Information!$B$1="","",IF(OR(Information!$B$1="Std. 9 A",Information!$B$1="Std. 9 B"),"Hindi1","Hindi2"))

[mso3]

Hi Glenn,
Thank you. Now it's working fine.

Thank you.

[Glenn Kennedy]

You're welcome.. and apologies for mucking it up first time...

[mso3]

Dear Glenn,
Please don't mind.

You have solved my problem and I appreciate you for the same.

Thank you and have a nice day.