IF Statement with Columns?

I am trying to type a formula that will perform the IF statement results. I am unable to make it work on Google Sheets.

I have columns from A to EQ. I want to have the formula focus on the B2.

• If B2 says "D" for column D and it is less than Z, then the statement is true.
• If B2 says "AC" for column AC and it is greater than Z, then the statement is false.

Formulas I tried to do: =IF(B2<"Z","DO THIS","IF NOT, DO THIS THEN")