CODEWITHSUNDEEP
arraysif-statementgoogle-sheetsgoogle-sheets-formulaarray-formulas
Jonathan Ambriz
Jonathan Ambriz

Reputation: 29

Google Sheets Formula development

I have tried the same idea multiple ways and have now idea why I keep getting a formula parse error. It's probably incredibly simple. B column is populated with Y or N and I want the next column to be the antithesis.

= IF ( B2, 'N', 'Y')

Upvotes: 1

Views: 29

Answers (2)

player0
player0

Reputation: 1

try:

=ARRAYFORMULA(IF(B2:B="Y"; "N"; "Y"))

Upvotes: 1

Kessy
Kessy

Reputation: 1994

@BigBen comment is the correct answer.

You are using IF(B2, condition if true, condition if false). In your case you are checking if B2 = TRUE

You have to check if B2 = "Y" and that is @BigBen comment:

=IF(B2="Y","N","Y")

You can check how this and all the other Sheet Functions work at the documentation

Upvotes: 1

Related Questions