CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Rajarshi
Rajarshi

Reputation: 2509

Simple ArrayFormula not working for columns in Google Sheets

As I was learning and testing formulas for Google Sheets, I found out that the ArrayFormula is not working as expected. Below is an image to help you understand:

ArrayFormula not working for columns

I was trying to say 'hi' to girls and 'yo' to boys using the formula:

=ArrayFormula(if($A1 = "boy", "yo", "hi"))

…but it seem to be not happening.

Upvotes: 0

Views: 775

Answers (1)

z..
z..

Reputation: 13156

Change $A1 to A1:A: the cell reference must be a range and the dollar sign is not needed since you aren't going to drag the formula.

Upvotes: 3

Related Questions